copy conditional formatting using built in feature?

  • Thread starter Thread starter eggman2001
  • Start date Start date
E

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?
 
eggman2001 said:
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?
Click to expand...


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.
 
Back
Top