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