format cell colour if day is a saturday or sunday?

[merlin777]

I'm trying to use a conditional formatting formula to colour a cell if the date it contains is a saturday or sunday.

I actaully need to do a whole column of 31 cells on 12 sheets but i can't even get one to format.

I'm using this for the formula to try to colour A11 which is a saturday:

or(weekday(A11)=1,weekday(A11)=7)

but it doesn't format.

What am I doing wrong, please?

To cover 31 cells across 12 sheets do I just use the format painter to copy the format or this cell to the others?

TIA

 

[fhqwgads]

you need a = infront
=or(weekday(A11)=1,weekday(A11)=7)

 

[merlin777]

Well i'll be jiggered. I did put one originally and excel complained so I removed it and excel added it's own one. I had a formula in that box identical to yours and it didn't work! Thanks!