Color field if date equals certain criteria
 

I have a list of dates in column A.
I have todays date in cell C1.
I want the date fields in column A to turn amber when they are equal to or
less than 15 days from todays date, then red when they are overdue.
Whats the formula for this please.

Color field if date equals certain criteria
 

Hi,

Select your range then

Format|Conditional format
Select formula is and enter the formula
=AND(A1<=TODAY(),A1TODAY()-15)
Pick amber
Click ADD
Select formula is and enter the formula
=A1<=TODAY()-15
Pick red

You don't need to use the date in C1

Mike


"RC" wrote:

I have a list of dates in column A.
I have todays date in cell C1.
I want the date fields in column A to turn amber when they are equal to or
less than 15 days from todays date, then red when they are overdue.
Whats the formula for this please.