Conditional formatting problem. If a WEEKDAY is a 7 OR a 1

Hello,

I currently have 3 conditioning formats running down the page which highlights a row depending on if its adjacent date is a: 7(sat), 1(sun) or a 2 (mon).

Seeing as i want 7 and 1 the same colour and i would like the 3rd conditional format to be freed up for another use, i was wondering if there was a way to combine 7 and 1 in my formula so that they could BOTH be the same colour. (Don't know why i didn't do this to begin with actually)

My current formula is =WEEKDAY($A6)=7 but i would like it if it could be changed into =WEEKDAY($A6)=7,1 or something similar. I'm not too sure how to phrase it though.

Any help much appreciated

Thanks guys

Try this: =OR(WEEKDAY($A6)=7, WEEKDAY($A6)=1)

Or this:

=WEEKDAY(A1,2)>=6

wow, quick reply. thanks for your help-it works great.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save