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