Coloured rows

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


--
sonic-the-mouse

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

--
Don Guillett
SalesAid Software
[email protected]
"sonic-the-mouse" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> sonic-the-mouse

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"sonic-the-mouse" <[email protected]> wrote
in message news:[email protected]...
>
> 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

>
> This would continue for a whole year.
>
> Any help would be appreciated
>
> stm
>
>
> --
> sonic-the-mouse