Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Coloured rows | New Users to Excel | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |