I have a very large report that is distributed daily that requires thousands of rows of data that need to be reviewed. I’m trying to make it easier for the user to read the rows in groups by highlighting the alternate groups. Similar to when you use the Format as Table feature and every other row alternates color. But in this instance, I want to group a number of rows together in the same color based on a shared value and alternate the color for each grouped set of rows. Any idea on how to manage this and what conditional formatting formulas or other features I could use to accomplish this?

Example to keep it simple: if I wanted to alternate rows between different Objects in the below so that it would be grey for Apple, white for Orange and grey again for Watermelon, how would I do this:

AisleObjectAttribute1AppleRed1AppleRound1AppleSmall1OrangeOrange1OrangeRound1OrangeSmall2WatermelonGreen2WatermelonLarge

​I have a very large report that is distributed daily that requires thousands of rows of data that need to be reviewed. I’m trying to make it easier for the user to read the rows in groups by highlighting the alternate groups. Similar to when you use the Format as Table feature and every other row alternates color. But in this instance, I want to group a number of rows together in the same color based on a shared value and alternate the color for each grouped set of rows. Any idea on how to manage this and what conditional formatting formulas or other features I could use to accomplish this? Example to keep it simple: if I wanted to alternate rows between different Objects in the below so that it would be grey for Apple, white for Orange and grey again for Watermelon, how would I do this:AisleObjectAttribute1AppleRed1AppleRound1AppleSmall1OrangeOrange1OrangeRound1OrangeSmall2WatermelonGreen2WatermelonLarge   Read More

​