Thread: Duplicates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default Duplicates

What's the criteria?

--
Regards,

Peo Sjoblom

Portland, Oregon




"karyoker" wrote in
message ...

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