Consider a sheet with a bunch of values grouped together. The goal is to have Excel shade the entire row's background color differently for each differing group of Requisition.
The color is not important. There could be 500 different color changes. I suspect the normal use case is around manually choosing the color. Given that the number of color changes is unknown, it may be hard to automate.
How can I best show logical groupings of rows in Excel? My first attempt was by row color, but perhaps there's a better way?