=TEXT(the formula, "Your format here")

--
HTH

Bob Phillips

"ExcelFred" wrote in message
...
Hello,

I am using an Index formula to return translations set in defined cells.
I would like to highlight and hyperlink only given words returned by the
Index formula...and for the moment I do not manage to do it.
I have just access to formatting of the whole cell where index formula is
embedded.
The text to be returned by the indexed function is formatted as I want,
but
the index formula just returns the value without taking care of the
formatting.

Can anyone give me a hand on this?

Thanks