copy conditional formatting using built in feature?

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?
 
C

Clif McIrvin

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?


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top