Conditional formatting and Highlighting Day Range

  • Thread starter Thread starter shaunholtz21
  • Start date Start date
S

shaunholtz21

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
 
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
 
Back
Top