Using conditinal formatting to highlight weekends on Monday

cochrajl

New Member
Joined
Sep 19, 2014
Messages
27
Keep in mind that I know how to use the WEEKDAY formula to detect weekend days.

Here is the issue though...I run a report every day and I have conditional formatting set to highlight the current day and the previous day. How would I use conditional formatting to highlight the weekend days and the current day just on Monday. My current setup will get Sunday since it will be the previous day, but how would I get it to catch Saturday as well?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

cochrajl

New Member
Joined
Sep 19, 2014
Messages
27
So far this is what I have, but it highlights all weekend days on Monday. I need it to highlight the previous weekend days on Monday.
=AND(WEEKDAY(TODAY())=2,WEEKDAY($H1,2)>5)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,657
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top