Coloured rows
 

Max & Don

Thanks for your assistance. I have opted for the variation provided by
Max as it worked first time. Thanks again.

stm

Max Wrote:
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 atyahoodotcom
----


--
sonic-the-mouse

You're welcome !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sonic-the-mouse" wrote
in message ...

Max & Don

Thanks for your assistance. I have opted for the variation provided by
Max as it worked first time. Thanks again.

stm