Conditional formatting and Highlighting Day Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shaunholtz21@hotmail.com - 18 Jul 2007 16:29 GMT

Hi -

I was hoping someone could help. Here's what I have. Cell range
D1:T1. each cell in range has a specific date. I want to highlight
the date(s) in the range that fall within the next 7 days from today.
I was thinking this was fairly simple, however I can't seem to figure
it out. I can come close using the conditional formatting options, but
it's not right.

Any help would be greatly appreciated.

Thanks!
Shaun

Reply to this Message

Peo Sjoblom - 18 Jul 2007 16:51 GMT

Select D1:T1 starting from D1 (that way D1 would be the active cell), then
do format>conditional formatting, select formula is and use

=AND(D1<=TODAY()+7,D1>=TODAY())

now this will "unhighlight" cells that are past today for instance 07/19/07
will be highlighted today and tomorrow but on Friday it will not be. If you
want all dates that are less than or equal than 7 days from today change it
to

=D<=TODAY()-7

once you put the formula there, click the format button and select pattern,
then the colour. Finally click OK twice

Signature

Regards,

Peo Sjoblom

> Hi -
>
[quoted text clipped - 9 lines]
> Thanks!
> Shaun

Reply to this Message

shaunholtz@comcast.net - 19 Jul 2007 14:52 GMT

Peo,

Thank you for your help! That worked perfectly!!!!

Reply to this Message

Rate this thread: