How to copy conditional formatting

D

Dan

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

Gord Dibben

Dan

Paste Special>Formatting 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 CF>Formula is:


Gord Dibben Excel MVP
 
Top