Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - allowing for Blank Cells
I have a form that we are setting up to calculate the number of days someone
may have missed their due date on a project. We have if cell value is greater than 0 it turns the cell red if we have if the cell value is less than or = to 0 it turns green. But since not all of the projects have been entered if the cell is blank it still turns green. Any ideas to write a condition that recognizes a null value. I already tried if cell value is "null" - it didn't work. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting 2 cells | Excel Worksheet Functions | |||
Conditional Formatting based on other cells | Excel Worksheet Functions | |||
conditional formatting based on another cells formula result | Excel Discussion (Misc queries) | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |