Excel- Conditional Formatting to Highlight Saturday and Sunday

Question

I am trying make excel highlight cells that contain Saturday and Sunday dates in column P without a helper column.

Column P lists days of the weeks and dates that are plus 20 days of the dates listed in Column O

The formula for Column P is =(O2+20)

The formatting for Column P is dddd, m/d/yyyy

I used Conditional formatting in Column P of =WEEKDAY(P2,2)>5

This results in random highlighting of various days in column P rather than just highlighting Saturday and Sunday.

I do not want to add a True/False Helper column

Answer 1

My guess is that the "Applies to" range starts in P1 instead of P2.

Change the formula in the conditional formatting rule to

=WEEKDAY(P1,2)>5

Answer 2

Thanks! That was definitely a typo on my part. I'm trying to learn excel and formulas. I thought that the data starting in P2 means that I would use that as the applies to range. Clearly, I should have used P1 even though I have that as the header/label.

Your solution worked.

Answer 3

Danielle - Please mark Hans' proposed solution as the answer as you've indicated that Your solution worked.