Excel: Change row colour when value changes

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.

For more resources for Microsoft Excel