| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you change a format WITHIN a formula?
I know I can use multiple font colors within a single cell, but is it
possible to use a formula to generate multiple colors within the same cell? Excel will accept the following formula, but does not render the colors: =TEXT("Red","[red]")&" and "&TEXT("blue","[blue]") I may be using the wrong function, but I thought I had seen something like this in the past. Thanks for your help. Pete |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can you change a format WITHIN a formula?
no
-- Gary''s Student - gsnu200743 " wrote: I know I can use multiple font colors within a single cell, but is it possible to use a formula to generate multiple colors within the same cell? Excel will accept the following formula, but does not render the colors: =TEXT("Red","[red]")&" and "&TEXT("blue","[blue]") I may be using the wrong function, but I thought I had seen something like this in the past. Thanks for your help. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the font color using the Time format in a formula | Excel Discussion (Misc queries) | |||
| Can I change currency format using a switch/formula | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| HOW TO: In a formula, how to change the format of the resulting te | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Linear Mode
