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

DIPANKAR SARKAR 0 Reputation points
2024-11-13T12:04:40.2133333+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,024 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Olaf Helper 45,366 Reputation points
    2024-11-14T08:00:50.1166667+00:00

    How Can I delete #REF!

    You "delete" it by fixing the formula.

    0 comments No comments

  2. DIPANKAR SARKAR 0 Reputation points
    2024-11-16T05:11:20.75+00:00

    Screenshot (62)

    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.

    0 comments No comments

  3. Barry Schwarz 3,076 Reputation points
    2024-11-16T09:46:18.4033333+00:00

    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.
    0 comments No comments

  4. Jiajing Hua-MFST 11,785 Reputation points Microsoft Vendor
    2024-11-18T09:50:54.37+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.