Format colorful for a cell (that has formula)

[OverAC]

Dear All,

Formating colorful for a cell that has formula is posible?
For example: = "I'm " & 1 + 1 & "years old"
And the desired result is: "I'm 2 years old"

So, these is any way for me to do this. Please help. Thanks so much.

OverA

 

[Bob Phillips]

You could write a UDF to test if a cell has a formula

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function


and then use this UDF in the CF, like


=IsFormula(A1)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[OverAC]

Of course i can check it but. even when I know it is an formula, I wan
to format it (1 cell only) with more than 1 color

 

[Guest]

Hi,
I do not understand why you need more than one color in one cell - this is
not possible - cell has only one backgroung color. But each letter in text in
cell can have own color.

 

[OverAC]

Yes, you're right.
I dont want to format 2 color for the backgroup of that cell. I just
want to format letters of it. Normally, with a cell we can format many
color for its letter (as most 1 color for 1 letter) but I cant do this
if that cell doesnt contain 1 text but a formula. So my question is "is
these anyway to do this?".
Please discuss.
OverAC

 

[Dave Peterson]

Formulas don't support this type of character by character formatting.

 

[OverAC]

Thanks you all.
I just want to have some thing strange with this.
Thanks any way.
OverAC