software

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

Highlight A2
Formatgt;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?--
karyoker
------------------------------------------------------------------------
karyoker's Profile: www.excelforum.com/member.php...oamp;userid=29417
View this thread: www.excelforum.com/showthread...hreadid=504270What's the criteria?

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;karyokerquot; gt; wrote in
message ...
gt;
gt; I was using this to hide dups Now I cant get it to work...
gt;
gt; Highlight A2
gt; Formatgt;Conditional Formatting
gt; Cell =A1
gt; Format Set Color To White
gt; Ok Ok
gt; Copy A2
gt; Highlight Column
gt; Paste Special
gt; Select Formats
gt; Ok
gt;
gt; The color Doesnt Change....What Am I Doing Wrong?
gt;
gt;
gt; --
gt; karyoker
gt; ------------------------------------------------------------------------
gt; karyoker's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29417
gt; View this thread: www.excelforum.com/showthread...hreadid=504270
gt;
I figured it out I was only putting A1 in the formula box Instead of
=A1--
karyoker
------------------------------------------------------------------------
karyoker's Profile: www.excelforum.com/member.php...oamp;userid=29417
View this thread: www.excelforum.com/showthread...hreadid=504270