Copying Conditional Formatting

[Guest]

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

 

[Guest]

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

 

[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

 

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