How can I use conditional formatting to give me this:
(at each change of unique ID in col A-change the entire row colour)
id (colA) value (colB)
1 abc
1 abc
1 abc
2 efg
3 hij
3 hij
I found this on the net but isn't working reliably =MOD($A1,2)=0
Dave
Bookmarks