Copying conditional formats

[Blue Max]

I can't find anything in help about copying conditional formats to other
cells - very frustrated. Help infers that the Format Painter can be used,
but that copies all formatting (color, lines, etcetera). How do we just
copy the conditional format and none of the other formatting attributes?
Why can't we simply apply one of the existing conditional formatting rules
from the conditional format menu?

 

[muddan madhu]

copy the cell | go to edit | paste special | format | ok

 

[Daniel.C]

With XL2003 or XL2007, paste special formats does it.
Daniel

 

[Blue Max]

Yes, but it copies all the formats (colors, borders, conditional, etc). So
how do we copy JUST the conditional formatting without the other attributes.
I don't see any option for conditional formats under 'Paste Special'?

Thanks,
Richard

***************

 

[Blue Max]

Yes, but it copies all the formats (colors, borders, conditional, etc) in
Excel 2007. So how do we copy JUST the conditional formatting without the
other attributes. I don't see any option for conditional formats under
'Paste Special'?

Thanks,
Richard

***************
copy the cell | go to edit | paste special | format | ok

 

[MartinW]

Hi,

You can tap F5 (or Edit>Go To, or Ctrl+G)
This brings up the GoTo Dialog Box
Then click Special
Then check Conditional Formats and OK
You can then copy and paste them.

This will select all CFs in your selection set.

A better way is to select all the cells you wish to apply the CF to
before you apply the CF.

HTH
Martin

 

[Blue Max]

Thank you, Martin. See inline comments below:

Hi,

You can tap F5 (or Edit>Go To, or Ctrl+G)
This brings up the GoTo Dialog Box
Then click Special
Then check Conditional Formats and OK
You can then copy and paste them.

*********************
Are you saying that this will only cut the conditional formatting, without
any other attributes, from the selected cells? When the selection is pasted
to the destination cells, does it only paste the conditional formatting?
*********************

This will select all CFs in your selection set.

*********************
Does this mean that all the conditional formats in the copied selection will
be pasted, without any other formatting, into the destination cells? In
other words, are multiple CF rules applied to ALL cells or do the
destination formats simply match the source cell by cell?
*********************

A better way is to select all the cells you wish to apply the CF to
before you apply the CF.

*********************
Ideally, yes, but this can be difficult sometimes.
*********************

*********************
Meanwhile, we would like to share another option we have discovered. By
going to Home Tab > Conditional Formatting > Manage Rules, you can locate
the rule you want and then add the new range of cells (use commas between
ranges) to the cell ranges already associated with this CF rule. Works
well, but would still be much nicer if the user could simply use the 'Paste
Special' dialog to paste only the conditional formats, just as is the case
when pasting values only, formulas only, comments only, etecetera. Might
also be nice to have the ability to select the desired conditional format
rule(s) and then paste it/them into a group of cells.

Thanks,

Richard
*********************