Multiple Colors (at the same time) in a cell with a formula

[MACRE0]

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.

 

[Gord Dibben]

Multiple font colors in a cell is not possible with formulas.

You could paste special>values on the cells then do some manual or VBA
formatting to achieve your needs.


Gord Dibben MS Excel MVP

 

[Ron Rosenfeld]

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

 

[MACRE0]

Thanks.