Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've been through all the questions in here and I'm still having difficulty
grasping this. I want to conditional format dates that are 60 days, 30 days out and then when they are overdue. I keep seeing everyone saying to change the formula to "formula is", but I can't find that anywhere. All I can get to is the drop down box (Excel 2007) from the CF tab. I go to new rule and get 5 options. (Format all cells..., Format only cells..., Format only top or bottom..., etc. I've been through them and still no "formula is" option. Any help would be greatly appreciated. Just to clarify, I'm trying to color fill green when 60 days or more out, yellow when 30 days or less out and then of course red, when actually overdue. Thanks in advance for any help. James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting from Dates | Excel Worksheet Functions | |||
Conditional Formatting with Dates | Excel Worksheet Functions | |||
Conditional formatting dates | Excel Discussion (Misc queries) | |||
Conditional Formatting with Dates | Excel Worksheet Functions | |||
Help with Conditional formatting with Dates | Excel Discussion (Misc queries) |