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

"sonic-the-mouse" wrote
in message ...

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 <atyahoo<dotcom
----
"sonic-the-mouse" wrote
in message ...

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