Conditional Formatting, More than 3 needs

Closed
Excel_n00b - Jul 30, 2009 at 08:33 AM
 Excel_n00b - Jul 30, 2009 at 08:59 AM
Hello,
I am looking for a macro that will automatically check all values in column J10-J200 by:
IF the date listed as deadline in the column is Today or later, the whole ROW beside it and the cell turns red.
If it is one day from that deadline whole row turns yellow, "TBD" turns the whole row blue, old entries are light gray (&whole row corresponding) and NEW ENTRIES stay ORIGINAL COLOR (white usually).
Related:

1 response

Also, if today= FRIDAY I want there to be a bar across the 1st row that reads: "DISCUSS: FOR NEXT WEEK"
2