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" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> karyoker
> ------------------------------------------------------------------------
> karyoker's Profile:
> http://www.excelforum.com/member.php...o&userid=29417
> View this thread: http://www.excelforum.com/showthread...hreadid=504270
>

[karyoker]

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