I created a copy of a pivot table because I needed it to be editable but the entire background is white. I need some help in getting a macro to make the background alternate between Gray and White based on the Vial sections(A,1, A,10....) So that the Vial name row and the Samples within it and all the data alternate between Gray and White so that it will be easier to view each section.These files can be over 10,000 rows long and hundreds of columns wide so it will really help a lot.
Thanks
Bookmarks