Conditional Formatting

[liozzi]

Hi there,

could someone help
how if i want to white out the font, if there is duplication in a table range.
can it be done with conditional formatting?

Thanks in advance..

 

[dave3009]

Use Formula Is: =COUNTIF($A$2:A2, A2)>1 and set a white font format.

 

[texasalynn]

Try this in conditional format - where my data to look for duplicates is in Column H

formula is
=COUNTIF($H$6:$H6,H6)>1
then select format font color white

 

[liozzi]

Try this in conditional format - where my data to look for duplicates is in Column H

formula is
=COUNTIF($H$6:$H6,H6)>1
then select format font color white

Thank you so much. it works