Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Code Date Rows
I have a call back sheet that has call back dates and I would like to color
code the rows that I need to call back today to blue, prior to today red and after today to gray. I think it would be under conditional formatting but I haven't successfully figured it out yet. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Code Date Rows
Assuming the dates are in column A
For row 2, set conditional formatting for every cell in the row to: Condition 1 to: Formula is: =$A2<TODAY() patterns, colour = red Condition 2 to: Formula is: =$A2=TODAY() patterns, colour = blue Condition 3 to: Formula is: =$A2TODAY() patterns, colour = gray Copy the formats to the remaining rows Regards Trevor "Derek" wrote in message ... I have a call back sheet that has call back dates and I would like to color code the rows that I need to call back today to blue, prior to today red and after today to gray. I think it would be under conditional formatting but I haven't successfully figured it out yet. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Date formulas | Excel Discussion (Misc queries) | |||
count between start date and end date | Excel Discussion (Misc queries) | |||
Count rows with specific date | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions |