Copying Conditional Formatting

S

SMac

I know how to use the Painter brush to copy the format but I have roughly
3,000 lines to do this to therefore I don't want to copy and paste either
because I loose my current number in there.

Is there a was to do this in large chunks?

Thanks!
Stacey
 
S

swatsp0p

Hi, Stacey. Use Copy on a cell that has the format you want, then highlight
the range you want to contain this formatting. Click on Edit>Paste Special
and select Formats from the choice box that opens. Now, ONLY your format
will be pasted into the cells, leaving your data unchanged.

HTH
 
G

Gord Dibben

Info about the Format Painter.

Double-click on the paintbrush and it will stay selected as you paint around
the sheet until you single-click to enable it.


Gord Dibben Excel MVP
 
D

David McRitchie

Hi Stacey,
And if it helps, you can select cell using the name box.

Also if you want to format only the used part of a column you
won't be saving any space compared to formatting the entire
column.
 
Top