Conditional Formatting: Highlight Row 4 Weeks from now

[NorthBear]

Capture.PNG

Hello!

I've got a simple request that I can't quite figure out. I have a series of historical data with the week beginning (Mondays) listed in a column. I currently have conditional formatting that highlights the row that is the current week. What I'm trying to figure out is a formula that I can enter into conditional formatting that highlights the row that is 4 weeks from now. So for example, its currently the week of 02/10, so the week of 03/09 should also be highlighted.

Thank you for your assistance

[Phuocam]

Try this:

=AND($A2>TODAY()-WEEKDAY(TODAY()),$A2<=TODAY()+4*7)

[NorthBear]

Thanks for your help! I can make this work, but what I was really looking for was something similar to what I had pictured here.

Capture.PNG

I've been using the following formula to select the current week, but I'd like to be able to conditional format the two weeks separately in two formulas as pictured above.

Please Login or Register  to view this content.

[popipipo]

Please Login or Register  to view this content.

Work this formula better?

[Phuocam]

You can use the OR () function to conditionally format two weeks separately:

Please Login or Register  to view this content.