Multi Colored Text

[JustinWWolcott]

I'm building a gannt chart, and I'm using this as a formula:

REPT("|",M19*100)&REPT("|",(1-M19)*100)

where M19 is the percent complete

Is there any way to make the second part of the function "&REPT("|",(1-M19)*100)" a different color?

thanks

 

[JustinWWolcott]

almost like custom number formats, but in the formula bar? Possible?

 

[Norie]

Justin

The only way that I know of of colouring/formatting individual parts of a cell requires VBA.

And if the parts you want to do that with are results of a formula then you would need to convert the formula to the resultant value.

Are you only using this formula on on cell?

If you are then perhaps you could consider using multiple cells and conditional formatting.

 

[JustinWWolcott]

Norie,

Thats exactly what I ended up doing

thanks for the reply though.