| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternating shading of varying groups of rows
I have rows that go together throughout an Excel spreadsheet. I want to
'tie' those rows together and then apply alternate shading according to those groupings. The desired groupings consist of 1 row to 6 rows. The desired result is to (1) tie varying number of rows together (2) be able to add or delete rows from those 'groups' (3) apply alternate shading to those groups (4) move those 'groups' around where Excel will automatically adjust the shading to still alternate. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use conditional formatting for alternating cell shading? | Excel Worksheet Functions | |||
| Sum rows in groups | Excel Worksheet Functions | |||
| redistribute a column by a groups of rows | Excel Worksheet Functions | |||
| Conditional formatting for groups | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Threaded Mode
