copy conditional formatting using built in feature?

[eggman2001]

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?

 

[Clif McIrvin]

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.