Want to link format of a cell to another cell along with the value

[NikunjThakkar]

HI All,

I am working on a file with multiple tabs. I have an output sheet which brings values from different tabs on to the output.

I am bringing the values using a simple VLOOKUP.

What I would like is to bring to the output sheet not only the value from the inner sheets, but also the cell color.

The cells are not colored using any logic or using conditional formatting, otherwise i would use the same logic or put the same conditional formatting for the output. The cells are colored by the users arbitrarily.

For Example, please refer the sample file. In this file, when I select Company A, the values are from the tab Company A, but the cell colors should also be the same as in COmpany A. When i select Company B, along with values, the cell colors should also change as per what is on the tab company B.

Is this possible?

Regards,
Nikunj

[FDibbins]

excel doesnt "see" colors, nor does it "see" formats - these are just cosmetics to make things easier for US to see. So there is no regular formula or function that will do what you want, sorry

Maybe some-one can put some VBA together for you

[NikunjThakkar]

For now as a temporary solution I'm having a letter "E" (standing for Extensive) in the colored cell. This will be an input manually. and then on the output sheet i will put a conditional formatting asking excel to color all cells containing the letter E in yellow.