Doesn't Edit|Copy, followed by Edit|paste copy the format for you?

Or are you looking for something else?

Edith F wrote:

Is there a way I can copy the format as part of a function. I am copying
cells from different worksheets and merging them into 1 worksheet and would
like to copy the format as part of the the copy function.
"Peo Sjoblom" wrote:

You can not only copy the color without copying the other formatting, but if
you want all the formatting you can select the cell with the formatting you
want and double click the paintbrush, now ever cell you select will have the
same formatting, click the paintbrush again to remove the copy mode, or you
can copy the cell and paste special and paste only format

Regards,

Peo Sjoblom



"Edith F" wrote:

I have 2 worksheets that I am merging into a single worksheet and am using
cells from one or the other worksheet based on conditions that I am checking.
In some cases the cell I want to copy have a different color text or
background and if I use that cells contents I also want to use the color but
it won't be used in all cases. How do I selectively format the cell color as
needed?

--

Dave Peterson