Hey guys i need your help on highlighting the duplicate value in two colors.
sample:
Name
aa
aa
aa
aa
bb
bb
cc
cc
cc
ff
ff
gg
gg
gg
Hey guys i need your help on highlighting the duplicate value in two colors.
sample:
Name
aa
aa
aa
aa
bb
bb
cc
cc
cc
ff
ff
gg
gg
gg
If you don't mind adding a helper column, then (assuming your data starts in A3) put the following in B3 and copy down:
Then have two conditional formats, one with red font using the following formula:=IF(COUNTIF(A:A,A3)=1,0,IF(AND(A2=A3,COUNTIF(A:A,A3)>1),IF(B2=0,B1,B2),IF(B2=0,B1,B2)+1))
andthe other in yellow font with the following formula:=AND(B3<>0,MOD(B3,2)=1)
Anything without a duplicate will have the default font color.=AND(B3<>0,MOD(B3,2)=0)
Hi chatz86
Assuming your data is in column A, with a header. For this example I am using column Z as a helper. In Z2:
Formula:=IF(A1=A2,Z1,NOT(Z1))
For the conditioning formatting rule, select cells A2:A15
Formula:=$Z2
Format as required.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
THANK YOU SO MUCH GUYS FOR THE HELP. I really appreciate it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks