Conditional Formatting

[JohnGuts]

I have added conditional formatting to several cells. The condition i
if A2=A1 then make text in A2 white (not visable). The problem I a
having is I have 10,000 cells that check to see if they are the sam
number as the one above it and the user does block copy and paste o
several 1,000's of numbers at a time. When they do the block copy an
paste into my conditionally formatted cells, my conditinoal formattin
is overwritten.

Is there anyway to allow the user to paste numbers into the cells an
still maintain the conditional formatting that I want?

Thanks for any help.

Joh

 

[mrice]

Have you tried Paste Special - values?

 

[JohnGuts]

You nailed it! It works GREAT! Thanks for the help!

John