Conditional formatting - highlight entire column when one cell contains date between today and 7 days prior

[Kurtin]

Hi there! I feel like I'm close to figuring this out... but if anyone has the answer to this, that would be very helpful


so, I'd like to format an entire column to be highlighted based on if the top cell contains a date that is less than today but greater than today-7 (in between today and 7 days prior) using the today function and I need it to continue to update which column is highlighted.

=E$1<today(),E$1>today()-7
this is what I tried using, which did not work obviously, the closest I got was using
=E$1>Today()-7
but this ended up highlighting everything after the first date.


thanks in advance!!!

 

[DanteAmor]

Try:

=AND(E$1>=TODAY()-7,E$1<=TODAY())

 

[Kurtin]

IT WORKED! thank you so much!

Try:

=AND(E$1>=TODAY()-7,E$1<=TODAY())