How Can I delete #REF! Error in Conditional formatting Manage Rule. It Become my worksheet Slower.

Question

How Can I delete #REF! Error in Conditional formatting Manage Rule. It Become my worksheet Slower.

Answer 1

How Can I delete #REF!

You "delete" it by fixing the formula.

Answer 2

Dear Sir,

How Can I bulk delete #REF! Error in Conditional formatting Manage Rule at a time, it's consume more time for deleting one by one.

It Become my worksheet Slower. so please prove any Shortcut for depleting this type of #REF! Error

Conditional Formatting.

Answer 3

There is no bulk delete feature in the conditional formatting rules manager. You can only work on one rule at a time.

An alternative is to copy all the used cells in the TMT-SUB worksheet to a new worksheet. This will preserve literal values and formulas.

• If TMT-SUB has named ranges, you will need to use the Name Manager in the Formulas tab to change the reference to the same cells in the new worksheet.
• If any formulas anywhere in the workbook reference worksheet TMT-SUB by name, you will need to change the reference to the new worksheet name.

Answer 4

Hi @DIPANKAR SARKAR

Thanks for your reply.

These "#REF!" errors should be certain cells. Have you deleted or added rows or columns before? Have you used custom "Names"?

If you can find back the correct reference cells to eliminate this error, perhaps that is a way.

Or you may clear all conditional formatting rules, and then apply the correct rules from scratch.