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.