I have multiple rows, each with a client ref in column A (in the format:
B01234) - the data is sorted in ascending order by column A.
I would like to define some conditional formatting, so that alternate client
refs are either yellow or white - where a client ref is repeated, the rows
are to be one colour. For example, if rows 2-5 relate to client ref B01234,
I want all the rows to be yellow. If rows 6-7 relate to another client, I
want the rows to be white. Then if row 8 was yet another client, the row
should be yellow again.
Any ideas what I should enter into the conditional formatting prompt?