EXCEL - INDIRECT (formatting the result)

L

Lynxbci3

I have a sheet with changing foratted text (e.g red, italic or Blue
Bold). I have an INDIRECT link to that cell. Can i pick up the forma
of that cell with the indirect link.

I.e if the cell has red text, give me red text etc etc

Thanks Al
 
J

Jason Morin

Unfortunately it can't be done with a formula. You'd have
to use an event macro to trigger the update of the cell
format. Here's a very simple example:

http://tinyurl.com/3dab6

HTH
Jason
Atlanta, GA
 
Top