We need more specifics. What is your conditional formatting formula?

Regards,
Fred.

"TLAngelo" wrote in message
...
Thank you for your response Fred. I don't understand though. If I put
the
same formula in the next column, nothing happens. I want to move the
numbers
that have only one instance to another column. My data is set up in two
columns, both columns should have the same data in them, but they do not.
I
have identified which numbers do not have a match and they all occur in
column b, but I wanted to move them to a new column so I won't have to
scroll
throuh the entire list.

Thanks,

Tania

"Fred Smith" wrote:

In your new column, simply put the same formula as you used in
conditional
formatting to change the format to red.

Or, If you have XL2007, you can use the Data Filter to filter by color.

Regards,
Fred.

"TLAngelo" wrote in message
...
I have an excel spreadsheet with two columns of data. I have used
conditional formatting to compare the two columns to find the numbers
that
do
not have a match (those numbers are now red font color). Now I would
like
to
take those red numbers and move them to another column. Can anyone
help
me?

Thanks,

Tania