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
|