software

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?

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 quot;formula isquot; in the drop down menu and with the first
cell of your selection as the starting point type something like:

=AND(TODAY()gt;=A1-14,TODAY()lt;=A1)
click on quot;Formatquot; and format as desired

HTH

Jean-Guy

quot;Wilsonquot; wrote:

gt; I have a spreadsheet where a task is entered and a completion date 6 weeks
gt; later is generated in another column (easy!)
gt;
gt; Can I get Excel to put in an automatic highlight on cells to flag up when
gt; this completion date falls within, say, 14 days of the day on which I look at
gt; the worksheet, so that I don't miss any deadlines?

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

Vaya con Dios,
Chuck, CABGx3
quot;Wilsonquot; wrote:

gt; I have a spreadsheet where a task is entered and a completion date 6 weeks
gt; later is generated in another column (easy!)
gt;
gt; Can I get Excel to put in an automatic highlight on cells to flag up when
gt; this completion date falls within, say, 14 days of the day on which I look at
gt; the worksheet, so that I don't miss any deadlines?

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

Cheers
Wilsonquot;CLRquot; wrote:

gt; Format gt; ConditionalFormatting gt; CellValueIs: Less than or equal to gt; type
gt; =TODAY() 14 in the rightmost window gt; Format gt; select the formatting desired
gt; gt; OK
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Wilsonquot; wrote:
gt;
gt; gt; I have a spreadsheet where a task is entered and a completion date 6 weeks
gt; gt; later is generated in another column (easy!)
gt; gt;
gt; gt; Can I get Excel to put in an automatic highlight on cells to flag up when
gt; gt; this completion date falls within, say, 14 days of the day on which I look at
gt; gt; the worksheet, so that I don't miss any deadlines?

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
quot;Wilsonquot; wrote:

gt; Thanks Chuck, does just what I want. For some reason Pinmaster's didn't, but
gt; maybe I did something wrong.
gt;
gt; Cheers
gt; Wilson
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Format gt; ConditionalFormatting gt; CellValueIs: Less than or equal to gt; type
gt; gt; =TODAY() 14 in the rightmost window gt; Format gt; select the formatting desired
gt; gt; gt; OK
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Wilsonquot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet where a task is entered and a completion date 6 weeks
gt; gt; gt; later is generated in another column (easy!)
gt; gt; gt;
gt; gt; gt; Can I get Excel to put in an automatic highlight on cells to flag up when
gt; gt; gt; this completion date falls within, say, 14 days of the day on which I look at
gt; gt; gt; the worksheet, so that I don't miss any deadlines?