RubberChicken
Board Regular
- Joined
- Jun 20, 2013
- Messages
- 50
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
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