Color formatting within a formula.

[omkar94]

Hello Guys,

Need some help on this one.

This is my formula =TEXT("3rd (E-L) / ","[Grey]#")&IF(MONTH($A$15)=12,10,5)&"th business day by 5 p.m."
This is what it displays = 3rd (E-L) / 5th business day by 5 p.m.

This is how i want it to display= 3rd (E-L) / 5th business day by 5 p.m.

I want the "3rd (E-L)" to be in grey.

I tried using the text formula, but no luck.

Please help!!! And no macros/vba please.

Thanks.

 

[Fluff]

AFAIK you cannot do that without VBA.

 

[omkar94]

Really? There is no other way around it? maybe conditional formatting?

 

[philwojo]

I can confirm what Fluff said, i had asked this before, other than VBA there is now way to do it in Excel, CF can't do it either.

 

[omkar94]

Thanks guys, for the help.
Can you please help me with the vba code then?