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? |
Alternating shading of varying groups of rows
You can use Conditional Formatting to provide for shaded rows.
See www.cpearson.com/excel/banding.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "AntDawg" wrote in message ... 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? |
Alternating shading of varying groups of rows
Thanks Chip. I checked this site out earlier and it is good at providing
guidance on groupings of equal numbers of rows. But I couldn't determine how this data applied to groups of rows that do not follow any pattern. Some of my groups will be 3 rows some 5, some 2. Thanks for the help. "Chip Pearson" wrote: You can use Conditional Formatting to provide for shaded rows. See www.cpearson.com/excel/banding.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "AntDawg" wrote in message ... 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? |
Alternating shading of varying groups of rows
The free Excel add-in "Shade Data Rows" may do what you want.
It shades by cell value or by every nth row. Shades just the selection or across entire sheet. Use any color in the color palette. Has option to ignore hidden rows. Download from (no registration required)... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "AntDawg" wrote in message 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? |
All times are GMT +1. The time now is 08:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com