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).
Configuration: Windows 2003 Internet Explorer 6.0
Conditional format formula to hide range of cells Conditional format if between values vba Conditional formats excel more than 3 patterns Conditional formatting date with in 30 days Conditional formatting more than 3 Conditional formatting row (duplicate from 2 columns) Excel 2007 conditional formatting 3 conditions formula Excel 2007 hide entire rows conditional formatting Excel conditional format insert text Excel conditional formatting if statement Excel conditional formatting more than 3 Excel conditional formatting to highlight expiry dates Excel disable conditional formatting Formula text conditional formatting Ms access 2007 conditional formatting more than 3 conditions Using conditional formatting to copy rows Vba conditional formatting more than 3 Vba excel conditional format detect color