Multiple Conditional Formatting on Dates
Assume the date is in A1:
CF1: Formula is =A1<=TODAY()+60
Format1: <font/<yellow
CF2: Formula is =A1<=TODAY()
Format2: <font/<red
In article ,
Frank wrote:
I have a spreadsheet that has promotion eligible dates for about 15 people. I
would like to have the background of the date change to the following colors
for the following circumstances.
At 60 days before the date I need the date to change to yellow to notify to
start processing paperwork.
If the date has passed I need it to turn red.
I can not figure out the correct formula for the cell to do both formats.
Thanks
|