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

Highlight A2
FormatConditional 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?


--
karyoker
------------------------------------------------------------------------
karyoker's Profile: http://www.excelforum.com/member.php...o&userid=29417
View this thread: http://www.excelforum.com/showthread...hreadid=504270