I was referring to returning your result in a format, such as #,##0.00 or
$0. I don't think you will get some red text in there, you would need to run
code on that.

--
HTH

Bob Phillips

"ExcelFred" wrote in message
...
What do you mean by "Your format here"?
here is my formula =INDEX(Language!$D$6:$K$1231,17,$B$10)
in line 17 of array, column "B10.value" is the text I want to display
with
the correct formatting ie sme words in the text are in red bold.

Following your advice, what should I do?
Define line 17 of array, column "B10.value" as text and on the calling
cell
enter :
=TEXT(INDEX(Language!$D$6:$K$1231,17,$B$10),"what here")

Can you provide me with step by step instructions?




"Bob Phillips" wrote:

=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