How to copy conditional formatting
 

Is there a way to copy conditional formatting to other cells, just like copy
formula? Right now, I have to do it manually for each cell. Thanks.

Dan

Paste SpecialFormatting is one way.

Using the PaintBrush would be another.

Note: when copying CF to other cells, you must make note of Relative and
Absolute addressing if using CFFormula is:


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 14:43:39 -0500, "Dan" wrote:

Is there a way to copy conditional formatting to other cells, just like copy
formula? Right now, I have to do it manually for each cell. Thanks.

Thanks so much.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Dan

Paste SpecialFormatting is one way.

Using the PaintBrush would be another.

Note: when copying CF to other cells, you must make note of Relative and
Absolute addressing if using CFFormula is:


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 14:43:39 -0500, "Dan" wrote:

Is there a way to copy conditional formatting to other cells, just like
copy
formula? Right now, I have to do it manually for each cell. Thanks.

You're welcome.

Thanks for the feedback.

Gord

On Thu, 31 Mar 2005 12:53:49 -0500, "Dan" wrote:

Thanks so much.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Dan

Paste SpecialFormatting is one way.

Using the PaintBrush would be another.

Note: when copying CF to other cells, you must make note of Relative and
Absolute addressing if using CFFormula is:


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 14:43:39 -0500, "Dan" wrote:

Is there a way to copy conditional formatting to other cells, just like
copy
formula? Right now, I have to do it manually for each cell. Thanks.