| 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? |
| 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 | |||
Threaded Mode
