Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Based on Due Dates
I want a stop light color to change from green, yellow, or red based on a
specific number of days prior to the due date. For example: If A1 is the stoplight color: 1) I want B8 green if the date in AE8 or AF8 is greater than 35 days prior to the date in the field. 2) I want B8 red if the date in AE8 or AF8 is less than or equal to 35 days prior to the date in the field. 3) I want B8 yellow if the date in AM8 or AN8 has passed. And I need to be able to replicate this for each record. Thanks! Jacob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format based on dates | Excel Discussion (Misc queries) | |||
conditional formula based on 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 |