Can Excel automatically flag up cells within given values?

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

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?

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?

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?