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 <at>yahoo<dot>com
----
"sonic-the-mouse" <[email protected]> wrote
in message news:[email protected]...
>
> Max & Don
>
> Thanks for your assistance. I have opted for the variation provided by
> Max as it worked first time. Thanks again.
>
> stm