Hi guys I have a spreadsheet with thousands of rows. I want to break the row colour up by the reference in column A. 2 alternating colours is fine. It is only to make the data easier to read and see the groups. So the reference is repeated in column A over a variable amount of rows. Then a new reference for the next few rows and so on. I'd like the row colour to change when the reference changes. I think I have seen it done with a =MOD formula and conditional formatting, but I can't find that now. Any ideas? Cheers
This question generated 15 answers. To proceed to the answers, click here.
This thread is current as of March 17, 2017.