copy conditional format without using format painter


M

MsConfused

Hi,

I am looking to copy the conditional formatting of a cell into another cell
without copying any other formatting (eg borders). Neither Format painter
nor paste special/format allows me to do this.

Can anyone advise?

Thank you
 
Ad

Advertisements

S

Sheeloo

Select the cell containing the Conditional Format you want to copy
CTRL-Click on the other cell (or range of cells such that source cell
remains seleceted)
Choose Format->Conditional Formatting
You will see the formatting already applied to the source cell
Click OK
 
Ad

Advertisements

M

MsConfused

Thanks Sheloo,

I forgot to specify that I'm trying to copy the conditional formatting
across different workbooks, and this suggestion doesn't hold across two
different worksheets or workbooks. Your suggestion does work for me with a
tedious workaround (ie. copying the data from the source workbook to a
section of the target workbook/worksheet then applying the action below), but
wondering if there's a better method?
 

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