Colouring text in VLOOKUP formula
 

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

Colouring text in VLOOKUP formula
 

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

On Wed, 10 Sep 2008 14:56:03 -0700, Trevor Williams
wrote:

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

Colouring text in VLOOKUP formula
 

Thanks Gord, just as I suspected...

"Gord Dibben" wrote:

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

On Wed, 10 Sep 2008 14:56:03 -0700, Trevor Williams
wrote:

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