conditional format change
 

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?

conditional format change
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djed" wrote in message
...
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?

conditional format change
 

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djed" wrote in message
...
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?

conditional format change
 

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

"djed" wrote in message
...
That's the formula I had. I tried re-entering it and the problem remains.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djed" wrote in message
...
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?

conditional format change
 

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

"David Biddulph" wrote:

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

"djed" wrote in message
...
That's the formula I had. I tried re-entering it and the problem remains.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djed" wrote in message
...
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?