Index Match Function Help

[Shwets]

Hi,
I need to have an INDEX MATCH function return a value AND FORMATTING (color coded numerical values).

I have been looking everywhere and cannot find any help on how to retrieve/match formatting from one set of data to another.

Any ideas? THANK YOU!!!

 

[Aladin Akyurek]

Formulas cannot fetch such formatting.

 

[Shwets]

Thank you, Aladin.

Is there anything I can do? Would a macro be able to do that for me?
And if so is there anywhere, that you could mention, I could look up one (ie. macro reference database?), or will I have to attempt to write it (I haven't done so since a basic course in college)?

Thank again!