Yes, have a look at Conditional Formatting under the Format menu.

Start by selecting the cells you wish to flag, then go to Format/Conditional
Formatting next select "formula is" in the drop down menu and with the first
cell of your selection as the starting point type something like:

=AND(TODAY()=A1-14,TODAY()<=A1)
click on "Format" and format as desired

HTH

Jean-Guy

"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?