Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting based on dates
I would like to shade cells in my spreadsheet based on information contained
within two date fields: Column E = Target Date Column F = Complete Date (left blank until task completed) Column G = Status (shaded yellow if today's date is equal to col. E and col. F is null; shaded red if today's date is past col. E and col. F is null; shaed grey if col. F contains any date (is not null). Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based upon due dates | Excel Worksheet Functions | |||
Conditional Formatting Based on Due Dates | Excel Worksheet Functions | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions |