Coloured rows

[sonic-the-mouse]

I am working on a staffing worksheet and wish to highlight the rows for
the weekend. I have tried conditional formatting but I dont have the
know how to have just saturday and sunday rows coloured.
e.g.
Colin Gary Julie Debbie
Mon
Tues
Wed
Thurs
Fri
Sat
Sun

This would continue for a whole year.

Any help would be appreciated

stm

 

[Don Guillett]

try formula is
=weekday(a2,2)>5

 

[Max]

A variation of Don's suggestion ...

If you have it set-up with the days in A2 down, i.e.:

Mon
Tues
Wed
Thurs
Fri
Sat
Sun

etc

Press CTRL+A to select the entire sheet
Click Format > Conditional Formatting

Under Condition1, make the settings as:
Formula is| =OR($A1="Sat",$A1="Sun")
(Note that the dollar signs are important!)

Click Format button > Patterns tab > Gray? > OK
Click OK at the main dialog

Entire rows with either "Sat" or "Sun"
as the row headers in col A will be colored gray