Hello,

i have a spread sheet with about 10 columns and about fifty rows and names in it (these will change on daily basis), some cells have duplicate names in them, i would like a formula to highlight the duplicate names across the cells. and then if there is more then 2 in one color, 3 or more in another color and so on, 4 or more in another color and so on.
so the base is for the formula to check across the spreadsheet and highlight matches with in it.

EG

row 1 -dave smith dave frank benny sue sue dave
row 2 -dave paul ged frank benny sue sue
row 3 -ros smith dave frank nigel sue ros sue

dave will highlight 4 times - green
frank 3 times red
sue 3 times red (or if possible another color because its a different row

thank you in advance Paul.