How to copy conditional formatting

  • Thread starter Thread starter Dan
  • Start date Start date
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.
 
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
 
Thanks so much.

Gord Dibben said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
copy conditional formatting range 3
Copying Conditional Formatting to range of cells 8
Excel Conditioning Formatting 3
Condition formats have $ sign problem copying 1
copying a cell that has been formatted to cell with conditionals 1
Conditional format copying 3
Excel Conditional Formatting 1

Back
Top