Nice solution Shane.

yclhk

why can't you use 2 cells next to each other?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ShaneDevenshire" wrote:

Hi,

You can't really do that with a formula, but you can fake it.

If your formula is in cell B6 then enter =LEFT(B6,3) in cell E6 and
=RIGHT(B6,6) in F6. Format E6 to red and F6 to blue. Resize the columns so
they "appear" directly next to each other. Turn of gridlines or change the
cell borders to white.

If that isn't good enough you can select E6:F6 and clicking the Camera tool,
then clicking a cell where you want to see the result. With the picture
selected choose Format, Picture, Colors and Lines, Line Color, No Line.
Resize the cell where picture is so the cell is identical in size to the
picture.


--
Cheers,
Shane Devenshire


"yclhk" wrote:

How to set the font color returned by lookup in a cell ?

The formula in a cell is :
=IF(B2=0,"","Tel : "&VLOOKUP(B8, A23:B41, 2,FALSE))

What I expect is, the word "Tel:" is red and the number returned by lookup
is blue and the cell remaining blank if no data in cell B2.

Thanks,