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.