| 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 |
| 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) | |||
Threaded Mode
