Thread: Font Color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yclhk yclhk is offline
external usenet poster
 
Posts: 48
Default Font Color

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,