Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Im using conditional formatting to change the color of a cell to blue if the
date entered in that cell is less than todays date. The formula works fine as long as theres any date in the cell. The problem is when the cell is empty, it is also turns blue, but I would like it to have no formatting. I tried to fix this by adding a second condition, but it still didnt work. Does anyone know how I can fix this? My conditions look like this: Condition 1: Forumla Is =G3<TODAY() --- color is blue. Condition 2: Cell Value Is equal to 0 --- color is no color |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting (Dates) | Excel Worksheet Functions | |||
Conditional Formatting - Dates | Excel Discussion (Misc queries) | |||
Conditional Formatting with Dates | Excel Discussion (Misc queries) | |||
Conditional Formatting w/ Dates | Excel Discussion (Misc queries) | |||
Conditional Formatting Dates | Excel Worksheet Functions |