Colouring text in VLOOKUP formula

[Trevor Williams]

Hi all, simple question (I think)...

I have a text cell made up of a vlookup and some other text. What I want to
do is colour the 'non-looked up' text a different colour.

Here's my formula:
=VLOOKUP(AcctNo,AcctList,2,FALSE) & " | some other text"

Any ideas gratefully received.

Trevor Williams

 

[Gord Dibben]

Cannot be done with a formula.

Formulas return values and parts of those values cannot be formatted within
the formula.


Gord Dibben MS Excel MVP

 

[Trevor Williams]

Thanks Gord, just as I suspected...

Cannot be done with a formula.

Formulas return values and parts of those values cannot be formatted within
the formula.


Gord Dibben MS Excel MVP