Duplicates

[karyoker]

I was using this to hide dups Now I cant get it to work...

Highlight A2
Format>Conditional Formatting
Cell =A1
Format Set Color To White
Ok Ok
Copy A2
Highlight Column
Paste Special
Select Formats
Ok

The color Doesnt Change....What Am I Doing Wrong?

 

[Peo Sjoblom]

What's the criteria?

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[karyoker]

I figured it out I was only putting A1 in the formula box Instead of
=A1