Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
COPYING CONDITIONAL FORMATTING TO A COLUMN | Excel Worksheet Functions |