| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating not working
Greetings all. I have a formula in E3, =SUM(D6:F6). I have a formula in E4
which is to sum three other cells. In E5 I have formula =E4-E5. I have conditional formating on E5 as cell value is equal to 0, change background color to green. If the value of E5 is 0, based on the formula in it, the conditional formatting does not work. However, if I manually type in 0, then it turns green. Does anyone know why this would be happening? All cell involved are formattted as number with no decimals. Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| working with #N/A and conditional formating | Excel Discussion (Misc queries) | |||
| working with graphics and formating them | Excel Discussion (Misc queries) | |||
| Conditional Formating working when data is entered later | Excel Worksheet Functions | |||
| Conditional Formating - formula not working | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Threaded Mode
