how do i copy the format of a cell from one worksheet to another

[Edith F]

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?

[Peo Sjoblom]

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?

[Edith F]

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]

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

[Edith F]

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]

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