| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shading alternate "groups" of rows?
I know how to use e.g. MOD functions to conditionally format alternate rows
with shading, but what is the best way to do this if your data is in groups so that you rather than have alternate rows of grey and white shading, you might have 5 items in one group that you want grey, then 3 in white, then 7 of grey etc, based on the value in a cell eg Column 1, Column 2 [GREY SHADING]category 1, blah... [GREY SHADING]category 1, blah... [GREY SHADING]category 1, blah... [GREY SHADING]category 1, blah... [WHITE SHADING]category 2, blah... [WHITE SHADING]category 2, blah... [GREY SHADING]category 3, blah... [GREY SHADING]category 3, blah... [GREY SHADING]category 3, blah... [GREY SHADING]category 3, blah... [GREY SHADING]category 3, blah... so the shading reflects alternation between different categories for ease of viewing/picking out visually... I want category 1 rows in light grey, category 2 rows in white, category 3 rows in grey again etc.. the categories will be text, I won't always know what it is either, so I can't pick out a number from it. tks in advance for any assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternate shading colors | Excel Discussion (Misc queries) | |||
| Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
| Summing Alternate Rows | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
Threaded Mode
