View Single Post
  #2   Report Post  
Old September 27th 07, 07:54 AM posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default How do i change font colors for different results in the same cel.

Take a look at Conditional Formatting in XL Help.

In article ,
kashof wrote:

for Expl:im using an IF formula: IF(Sum(E6:E15)100,TRUE,FALSE)
i want True value to be shown in same cell in Blue while False to be shown
in Red in same cell.can it be done???