| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Text Function change output text color?
Hello,
The folowing forumal is used in part of a CONCATENATE function, and everything works great, except the code below doesn't make the text red. =TEXT(VLOOKUP(vUtility_Company,Table4,7,FALSE),"[<=9999999][Red]###-####;[Red](###) ###-####") Any ideas how to get the text red only in the portion above and not the whole CONCATENATE statement? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can Text Function change output text color?
On Tue, 30 Dec 2008 18:28:00 -0800, epiekarc
wrote: Hello, The folowing forumal is used in part of a CONCATENATE function, and everything works great, except the code below doesn't make the text red. =TEXT(VLOOKUP(vUtility_Company,Table4,7,FALSE), "[<=9999999][Red]###-####;[Red](###) ###-####") Any ideas how to get the text red only in the portion above and not the whole CONCATENATE statement? You will need to execute a VBA Macro which does the concatenation writes the text string to the cell then formats the particular portion in accordance with your formatting rules. Differential formatting, of the type you describe, can only be done on a text string. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color or type size in an Excel TEXT function | Excel Discussion (Misc queries) | |||
| Can an Excel logic function change the color of a cell or text? | Excel Worksheet Functions | |||
| Change text color | Excel Discussion (Misc queries) | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
| Change Text-color depenting on SUM-function | Excel Worksheet Functions | |||
Linear Mode
