Copying Conditional Formatting
 

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

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 EditPaste 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

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

On Thu, 10 Mar 2005 10:51:04 -0800, "SMac"
wrote:

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

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Gord Dibben" <gorddibbATshawDOTca wrote ...
Double-click on the paintbrush and it will stay selected as you paint around
the sheet until you single-click to enable it.

Stacey -- "SMac" wrote...
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?