How to copying conditional formatting using the fill handle.

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

 

[JP]

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

 

[Gord Dibben]

How about using the Formatting Paintbrush?

Double-click if you want to keep it active.

Single-click when done.


Gord Dibben MS Excel MVP