conditional format change

[djed]

I had a conditional format to turn a cell red if its formula evaluated to not
equal to zero. An adjacent cell with text was formatted to do the same if the
first cell didn't equal zero. Both of these worked in Excel 2003, but since
updating to 2007 the formula cell works but the text cell doesn't. If I open
the CF editor on the text cell and then close, it evaluates correctly. But
when the value changes to zero, the text stays red until I edit again. What
can I do to fix it?

 

[Bernard Liengme]

In F1, I have =SUM(A1:A10) while in G1 I have some text
I selected F1:G1 and opened the CF dialog
This is the rule that I applied: =$F$1<>0 with a red font
If F1 evaluates to 0 both F1:G1 have black font, otherwise both are
displayed in red
best wishes

 

[djed]

That's the formula I had. I tried re-entering it and the problem remains.

 

[David Biddulph]

Go into CF for G1, copy the formula from the "Formula Is" dialogue, and
paste it here.

 

[djed]

This is in K2:
=$K$3<>0

Go into CF for G1, copy the formula from the "Formula Is" dialogue, and
paste it here.