It already was set to automatic. Formulas calculate fine - it's just
the conditional formatting having the problem.



On Apr 14, 5:27*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Turn your calculation mode to automatic.

ButtonExcel OptionsFormulasCalculation Options.

Gord Dibben *MS Excel MVP

On Wed, 14 Apr 2010 09:38:54 -0700 (PDT), Mel wrote:
Excel 2007

Conditional formatting is not changing formatting unless something is
triggered to refresh the screen.

For example, cell D5 has the following rule: =G5<"" format with blue
fill. When I manually type an entry into G5, D5 fills properly. But if
I delete (delete, not space) the G5 entry, the blue fill is not
removed from D5. BUT... when I task swap to another program and come
back, it takes effect. D5 is then restored to no fill.

So, conditional formatting is formulated correctly and I'm doing
things correctly, but Excel's screen isn't refreshing automatically -
only when I pop over to another program and come back.

The only time it works right is if I manually make the entry in G5. if
I paste an entry into a previously blank G5, nothing happens to D5.
Also if I autofill down or CTRL+D to populate and entry into G5, D5 in
unaffected. BUT... then all these work correctly once I task swap to
another program and come back. The screen somehow refreshes to correct
its conditional formatting.

Is there a way to fix this?

-Melina