Conditional Formatting

[abuharvey]

Dear All,

I need a Conditional Formatting Formula to indicate the additional Duplicated Entries in different color, the first entry should be in default color the additional entry only in different color.

Daniel
Jose
Daniel
Maria
Jack
Jose


Thanks a lot

 

[amiroo]

hi

you can use this formula in conditional formatting

=COUNTIF($A$1:$A1,$A1)>1