Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For readability, I would like to be able to band a spreadsheet that has been
grouped. Either of the following solutions would work... Ex: Ford Mustang F-150 General Motors Corvette Silverado Honda S2000 Ridgeline Element 1. (Preferred) Alternate grey (G) and white (W) background on rows at level 1 and have all child rows inherit that background color. (G) Ford (G) Mustang (G) F-150 (W)General Motors (W) Corvette (W) Silverado (G)Honda (G) S2000 (G) Ridgeline (G) Element 2. (Acceptable) Set a grey background for all rows at level 1 and a white background for all child rows. (G) Ford (W) Mustang (W) F-150 (G)General Motors (W) Corvette (W) Silverado (G)Honda (W) S2000 (W) Ridgeline (W) Element Obviously, this involves Conditional Formatting, but how can I ask a row if it's group level or how can I band child rows to follow their parent row when the parent rows alternate background color? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
color Banding using visual basic | Excel Worksheet Functions | |||
Colour Banding in pivot tables | Excel Discussion (Misc queries) | |||
rubber banding | Charts and Charting in Excel | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
Banding Results | Excel Discussion (Misc queries) |