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?

Can Excel automatically flag up cells within given values?
 

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?

Can Excel automatically flag up cells within given values?
 

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?

Can Excel automatically flag up cells within given values?
 

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?

Can Excel automatically flag up cells within given values?
 

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?