How to copying conditional formatting using the fill handle.

  • Thread starter Thread starter Mikexmil
  • Start date Start date
M

Mikexmil

I'm trying to find a way of copying conditional formatting to adjacent cells
similar to using the fill handle when copying formulas from one cell to
another.
 
Right click on the fill handle and drag across the cells you want to
copy the conditional formatting to. When you let go of the right mouse
button, there's a little popup menu. Choose "Fill Formatting Only"


HTH,
JP
 
How about using the Formatting Paintbrush?

Double-click if you want to keep it active.

Single-click when done.


Gord Dibben MS Excel MVP
 

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

Help needed 0
Excel Macro to automatically go to the right of the last colored cell 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel VBA 1
conditional formatting in Excel 2007 1
Excel Conditional Formatting Removal 7
Question about conditional formatting of zeros in Excel 0
Excel 2007 - A Conditional Formatting ?'s 1

Back
Top