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!

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!