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?

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?

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?

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

Yes, that would work but I am trying to accomplish this without manually
copying and pasting, am hoping that I can do it as part of the vlookup
function that I am using to merge the worksheets.

"Dave Peterson" wrote:

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

Ahh.

The problem is that =vlookup() like all functions return values to the cell.
They can't change formatting.

Maybe you could use Format|conditional formatting (in both cells) to mimic the
formatting???

Edith F wrote:

Yes, that would work but I am trying to accomplish this without manually
copying and pasting, am hoping that I can do it as part of the vlookup
function that I am using to merge the worksheets.

"Dave Peterson" wrote:

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


--

Dave Peterson