Hello,
I've done some researches but havent found what i'm looking for .. I'd like to highlight duplicate cells (Name and Surname) (case insensitive). But with only 2 colors (or perhaps more like 4) - Light green/yellow (otherwise the cell won't be readable when printed...
Is it possible for a macro to look each row and search if "4 cell before and 4 cell after" there is a duplicate .. And if so, color it to one color ? then another color ?
Something like this...
Col B Col C
<tbody>
</tbody>
I don't want a rainbow of color. I'd like someting that help the reader to see the duplicates ( change the backgroun of the cell) , even if its a list of "Only duplicates" !
thanks in advance
William - VBA Total newbie
I've done some researches but havent found what i'm looking for .. I'd like to highlight duplicate cells (Name and Surname) (case insensitive). But with only 2 colors (or perhaps more like 4) - Light green/yellow (otherwise the cell won't be readable when printed...
Is it possible for a macro to look each row and search if "4 cell before and 4 cell after" there is a duplicate .. And if so, color it to one color ? then another color ?
Something like this...
Col B Col C
| NAME | SURNAME |
| ABBY | JEAN |
| DUPONT | William |
| DUPONT | WILLIAM |
| abby | jean |
| RANDOM | Guy |
| RANDOM | GUY |
| ABSIL | Eric |
| ABSIL | ERIC |
| ADAM | Bernard |
| Absil | eric |
<tbody>
</tbody>
I don't want a rainbow of color. I'd like someting that help the reader to see the duplicates ( change the backgroun of the cell) , even if its a list of "Only duplicates" !
thanks in advance
William - VBA Total newbie
