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

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

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"hgopp99" wrote in message
...
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

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

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