How to copying conditional formatting using the fill handle.
 

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.

How to copying conditional formatting using the fill handle.
 

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

On Mar 29, 2:28*pm, Mikexmil
wrote:
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.

How to copying conditional formatting using the fill handle.
 

How about using the Formatting Paintbrush?

Double-click if you want to keep it active.

Single-click when done.


Gord Dibben MS Excel MVP

On Sat, 29 Mar 2008 11:28:00 -0700, Mikexmil
wrote:

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.