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.