| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color of entire row by use conditional format | Excel Worksheet Functions | |||
| What does Conditional format change when highlighting? | Excel Discussion (Misc queries) | |||
| How do you use conditional format to change a bar color on a char. | Charts and Charting in Excel | |||
| How do I use conditional formatting to change subtotals row format | Excel Worksheet Functions | |||
| Conditional format (word change) | Excel Worksheet Functions | |||
Hybrid Mode
