Hello,

I'm using the Conditional Formatting tool on the Home>Styles ribbon to
format unique cells. I'd then like to copy and paste the formatted
cells so that there the conditional operation is no longer running on
them. For example, I have values in column A and B. The two columns
independently have only unique values, but have duplicate values
between them. I want to highlight the unique values and copy only
column B (along with the highlighting) to a new workbook.

Does anyone know how to do this?

"eggman2001" <(E-Mail Removed)> wrote in message
news:e63a68a4-f6b1-4f9c-aaf9-(E-Mail Removed)...
> Hello,
>
> I'm using the Conditional Formatting tool on the Home>Styles ribbon to
> format unique cells. I'd then like to copy and paste the formatted
> cells so that there the conditional operation is no longer running on
> them. For example, I have values in column A and B. The two columns
> independently have only unique values, but have duplicate values
> between them. I want to highlight the unique values and copy only
> column B (along with the highlighting) to a new workbook.
>
> Does anyone know how to do this?


I believe Paste Special | Formatting will preserve the results of the
conditional formatting. You would need a two step process (at least from
the user interface): 1) Copy the range (Column B) and Paste Special |
Formatting, then 2) Paste Special | Values.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)