On Jul 24, 9:14 am, Stephane Quenson
wrote:
I would add a new column let's say G. I also assume that the first row is for
headers and customer info starts at row 2. Put if G1 the value TRUE. Write
the formula on G2: =IF(A2=A1, G1, NOT(G1)) and copy it down the range. Now G
contains an alternance of TRUE and FALSE value. Select the whole range to
color, then use the conditional formatting (Menu Format Conditional
Formatting), select "Formula Is" and type "=$G2=TRUE" (without the quotes).

Thanks Stephane but that is not quite what I want to do as the sheet
automatically updates it data.

What I'm looking for is a vba solution which can be placed in the
onChange event handler.

But many thanks for the suggestion.

Kindest regards

Alan Newton