Retreiving font when matching data from one worksheet to another

[hgopp99]

I am using INDEX and MATCH to get data from one worksheet to another. But I
would like to collect the font color and bold characteristics. How can this
be done?
--
hgopp99

[Dave Peterson]

Not using formulas. They only bring back values.

hgopp99 wrote:
>
> I am using INDEX and MATCH to get data from one worksheet to another. But I
> would like to collect the font color and bold characteristics. How can this
> be done?
> --
> hgopp99

--

Dave Peterson

[Peo Sjoblom]

Not possible using formulas, I'd suggest copy and paste special as format

--
Regards,

Peo Sjoblom

Portland, Oregon




"hgopp99" <[email protected]> wrote in message
news:[email protected]...
>I am using INDEX and MATCH to get data from one worksheet to another. But
>I
> would like to collect the font color and bold characteristics. How can
> this
> be done?
> --
> hgopp99

[hgopp99]

I have a workbook with multiple worksheets. The first worksheet is a
"master" and is a compilation of the remaining worksheets which are subsets
of the first. There are cells on different worksheets that are color-coded
and bolded, etc that I would like to present in the "master". For example,
if I have a cell in Worksheet3 that is red, I would want it's corresponding
cell in Worksheet1 to be red. Unfortunately, the cells are not in the same
position. The cell in Worksheet3 might be in column B and the equivalent
cell might be in column A in Worksheet1.

Thanks in advance.
--
hgopp99


"Dave Peterson" wrote:

> Not using formulas. They only bring back values.
>
> hgopp99 wrote:
> >
> > I am using INDEX and MATCH to get data from one worksheet to another. But I
> > would like to collect the font color and bold characteristics. How can this
> > be done?
> > --
> > hgopp99
>
> --
>
> Dave Peterson
>

[Dave Peterson]

Maybe you can mimic the formatting via Format|conditional formatting???

But formulas won't return colors.

hgopp99 wrote:
>
> I have a workbook with multiple worksheets. The first worksheet is a
> "master" and is a compilation of the remaining worksheets which are subsets
> of the first. There are cells on different worksheets that are color-coded
> and bolded, etc that I would like to present in the "master". For example,
> if I have a cell in Worksheet3 that is red, I would want it's corresponding
> cell in Worksheet1 to be red. Unfortunately, the cells are not in the same
> position. The cell in Worksheet3 might be in column B and the equivalent
> cell might be in column A in Worksheet1.
>
> Thanks in advance.
> --
> hgopp99
>
> "Dave Peterson" wrote:
>
> > Not using formulas. They only bring back values.
> >
> > hgopp99 wrote:
> > >
> > > I am using INDEX and MATCH to get data from one worksheet to another. But I
> > > would like to collect the font color and bold characteristics. How can this
> > > be done?
> > > --
> > > hgopp99
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson