How to color every other line in an Excel spreadsheet. By Jim Gordon 2/15/2007. The Request.
By Jim Gordon
“I'm wondering if there's a way to color every other line with a slight grey color, using Normal view, in such a way that even if you Sort the data on those lines, the grey banding still remains where they are. I want to do this to produce a more readable document.
I've manually done this this alternative color banding, but whenever I re-sort the data, the colors get all messed up.”