LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do i change font colors for different results in the same cel.

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???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost highlighting and font colors; background colors on web pages Jan in Raleigh Excel Discussion (Misc queries) 2 July 31st 07 09:10 PM
How to add differnt font colors to Formula results Mini-zKris Excel Discussion (Misc queries) 2 March 17th 07 10:45 PM
Format a cell to recognize data and change font colors accordingly Dwood62 Excel Worksheet Functions 1 April 24th 06 04:54 PM
How do I change the font color based on results of an IF stateme MKLeisure Excel Worksheet Functions 2 December 16th 05 03:53 PM
Formula results in font color change Jeff P Excel Worksheet Functions 2 November 1st 04 08:28 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"