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

Similar Threads

copy conditional formatting range 3
Using Format Painter on multiple cells 3
Format Painter not working in Word 2010 3
Using Format Painter with Conditional formatting 0
typing in a new cell and carrying the formatting of the previous c 2
Copying Conditional formatting 2
How do I copy borders without erasing other destination formats? 0
Copying conditional formatting to an entire column in Excel 2007 3

Top