| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Colors (at the same time) in a cell with a formula
I'm trying to make a date stand out in a cell. My Cell should read as follows: Estimate Complete In August "August" or "In August" if need be is taken from another cell. ="Estimate Complete In "&A1 is a basic representation of how my formula bar displays. I've tried Custom Cell formating, but that seems to default only to one color, or show an error. Any and all help would be appreciated. -- MACRE0 ------------------------------------------------------------------------ MACRE0's Profile: http://www.excelforum.com/member.php...o&userid=10848 View this thread: http://www.excelforum.com/showthread...hreadid=572044 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Colors (at the same time) in a cell with a formula
Multiple font colors in a cell is not possible with formulas.
You could paste specialvalues on the cells then do some manual or VBA formatting to achieve your needs. Gord Dibben MS Excel MVP On Tue, 15 Aug 2006 21:15:05 -0400, MACRE0 wrote: I'm trying to make a date stand out in a cell. My Cell should read as follows: Estimate Complete In August "August" or "In August" if need be is taken from another cell. ="Estimate Complete In "&A1 is a basic representation of how my formula bar displays. I've tried Custom Cell formating, but that seems to default only to one color, or show an error. Any and all help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Colors (at the same time) in a cell with a formula
On Tue, 15 Aug 2006 21:15:05 -0400, MACRE0
wrote: I'm trying to make a date stand out in a cell. My Cell should read as follows: Estimate Complete In August "August" or "In August" if need be is taken from another cell. ="Estimate Complete In "&A1 is a basic representation of how my formula bar displays. I've tried Custom Cell formating, but that seems to default only to one color, or show an error. Any and all help would be appreciated. As far as I know, at least through Excel 2002, there is not support for what you want to do. To have different characters in a cell formatted differently, you need to have a text string in that cell. For example, you can select a few characters within a cell and bold them. Or you can do it with a macro. But unless this has changed in subsequent versions of Excel, you cannot do it with a formula in the cell. --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Colors (at the same time) in a cell with a formula
Thanks. :( -- MACRE0 ------------------------------------------------------------------------ MACRE0's Profile: http://www.excelforum.com/member.php...o&userid=10848 View this thread: http://www.excelforum.com/showthread...hreadid=572044 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for displaying in 1 cell Lowest value from multiple other cells | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
| Click in cell w/ formula and get colors in referenced cells | Excel Discussion (Misc queries) | |||
| Changing a cell referent in a formula several at a time... | New Users to Excel | |||
Linear Mode
