Share via

Conditional Formats lagging

Anonymous
2013-05-17T18:51:53+00:00

I have a file using conditional formatting.  I have many cells with multiple conditions (color-coded key words).

Lately, when I change a cell value, the conditioning doesn't change to match.  If I open Conditional Formatting and I edit a rule, then all of the unchanged formats suddenly "wake up" and make their changes.  It is as if I needed a refresh button.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2013-05-17T18:59:22+00:00

I have a file using conditional formatting.  I have many cells with multiple conditions (color-coded key words).

Lately, when I change a cell value, the conditioning doesn't change to match.  If I open Conditional Formatting and I edit a rule, then all of the unchanged formats suddenly "wake up" and make their changes.  It is as if I needed a refresh button.

Hi,

It sounds like the calculation method has been set to manual.

Formulas tab | Calculation Options | Select 'Automatic'

Was this answer helpful?

2 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-06-25T19:35:43+00:00

    I was actually running into the same problem, but upon saving the document, closing it, and re-opening the document the lagging was fixed.  I'll have to wait and see if it returns or if other users of the document report the issue.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2014-06-25T19:23:37+00:00

    Nope, I'm having the same lagging issue and the Calculation Options is already set to Automatic.

    Was this answer helpful?

    0 comments