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

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.

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

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