| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup formula editing based on numbers treated as text | Excel Worksheet Functions | |||
| How do I replace my vlookup FORMULA with just the TEXT of results | Excel Worksheet Functions | |||
| How do I set up a cell colouring formula in Excell 2003? | Excel Worksheet Functions | |||
| Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
| VLOOKUP formula to text | Excel Discussion (Misc queries) | |||
Linear Mode
