On a sheet I have a list of names with information beside it. The name may
repeat several times one after the other in the list and the list could be
anywhere from 1 to 140 rows. So it is easier to read I was wondering whether
it is possible to change the cell shading (for part of the row) based on the
name automatically?

The names would be unknown to the macro:

Name1 <yellow shading
Name1 <yellow shading
Name1 <yellow shading
Name2 <the name changed, so pick another colour, blue
Name3 <the name changed, so pick another colour, green
Name3 <green shading
<blank <leave shading

I am pretty sure I could do all the coding, simply by reading each cell in
turn, checking the format and making changes as required ( or is there a
smarter way?) and run from say a button on the page, BUT can this macro be
started simply because someone changed the name in a cell?

--
Trefor