I'm a newbie to the forum, so bear with me.
I need a way to highlight a cell either Green, Yellow, or Red based upon a comparison of a Due Date (Column G) vs. Today's Date (cell B2) within a formatted table. I'm going to apply this formatting to a bunch of columns, but each column will have different date criteria.
Here's my sample criteria for cells in column M:
No Format: if Due Date cell (G7) is blank
Green: 10 or more days until due date
Yellow: 7-9 days until due date
Red: 6 or fewer days until due date
Currently in column M, I only have Blank, Red, and Green formatted and they are working. But I want it to work on all three colors
I have column P formatted, but it stops evaluating at Yellow. Here's my criteria for column P:
No Format: if Due Date cell (G7) is blank
Green: 8 or more days until due date
Yellow: 5-7 days until due date
Red: 4 or fewer days until due date
The other "Due Date" columns (S,V,Y,Z-AF) need to all have the same color coding, but will have different "days until due date" tolerances.
I'd also like it to either "lock" the color based on the actual date typed in to the Due Date column, or remove the color formatting when the actual date is input.
Sample workbook is attached.
THANKS for helping.
cbb
Bookmarks