| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formating using cells containg dates
I have a spread sheet that contains 3 date columns, column A is open date,
column F is due date, and column G is complete date, and column H is Status (RED,YELLOW,GREEN). I want column H to change to RED when the due date is overdue, to change to YELLOW when the due date is within 5 days of being overdue, and to change to GREEN when 6 days or less of the due date. How can I do this? The formula that I have in the cell is =IF(F9="","",IF(F9="",IF(TODAY()F9-5,"RED",""),IF(TODAY()=F9-5,"YELLOW","GREEN"))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
| Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| Sequential dates in different cells | Excel Worksheet Functions | |||
| Sequential dates in different cells | Excel Worksheet Functions | |||
Threaded Mode
