My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel 2007, is there any way to say 'alternate colour between Grey and White based on the matching names in row A'? Row A is sorted so that names are in order and together.
Bob (White) Bob (White) Derek (Grey) Jane (White) Jane (White) Jane (White) Jane (White) etc (Grey) etc (etc)