Retreiving font when matching data from one worksheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Not using formulas. They only bring back values.
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?
Click to expand...
 
Not possible using formulas, I'd suggest copy and paste special as format

--
Regards,

Peo Sjoblom

Portland, Oregon
 
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.
 
Maybe you can mimic the formatting via Format|conditional formatting???

But formulas won't return colors.
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.
Click to expand...
 
Back
Top