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.