Thanks for the feedback Wilson........for some reason, Conditional Formatting
is quite tricky, and things you think should work, just don't, and just a
small type-O can cause it to fail without notice also......anyway, glad you
got your's working.

Vaya con Dios,
Chuck, CABGx3



"Wilson" wrote:

Thanks Chuck, does just what I want. For some reason Pinmaster's didn't, but
maybe I did something wrong.

Cheers
Wilson


"CLR" wrote:

Format ConditionalFormatting CellValueIs: Less than or equal to type
=TODAY()+14 in the rightmost window Format select the formatting desired
OK

Vaya con Dios,
Chuck, CABGx3



"Wilson" wrote:

I have a spreadsheet where a task is entered and a completion date 6 weeks
later is generated in another column (easy!)

Can I get Excel to put in an automatic highlight on cells to flag up when
this completion date falls within, say, 14 days of the day on which I look at
the worksheet, so that I don't miss any deadlines?