Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 27th 07, 07:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
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???

  #2   Report Post  
Old September 27th 07, 07:54 AM posted to microsoft.public.excel.worksheet.functions
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???

  #3   Report Post  
Old September 27th 07, 08:05 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default How do i change font colors for different results in the same cel.

Say the cell you want to conditionally format is E1.

In E1, enter this formula:

=Sum(E6:E15)100

AND format E1 to a pattern of RED.

NOW, select E1 and from the menu bar:
<Format <Conditional Format
Change "Cell Value Is" to "Formula Is",
And enter the *same* formula in the right window:
=Sum(E6:E15)100

Click on "Format",
And set the pattern color to BLUE,
Then <OK out.

E1 will now be RED, and display FALSE until the values in E6 to E15 are
greater then 100, which will change the display in E1 to TRUE, and change
the color to BLUE.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"kashof" wrote in message
news
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???


  #4   Report Post  
Old September 27th 07, 08:13 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default How do i change font colors for different results in the same cel.

Yes. Look up conditional formatting in Excel help. Note that you'll need
the option for "Formula is" rather than "Cell Value is". Note also that you
need to be careful that Excel doesn't try to change the formula for you.
Start the formula with an = sign or else it'll probably start throwing quote
marks around. If you are using the formula across a range of cells you need
to be careful about the distinction between relative and absolute
addressing. When you've completed your conditional formatting, go back in
to make sure Excel hasn't changed it for you and that it's left you with the
formula you want.
It sounds like you need =Sum(E6:E15)100 for Blue and =Sum(E6:E15)<=100 for
Red
--
David Biddulph

"kashof" wrote in message
news
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???





Reply
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 11: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 04:53 PM
Formula results in font color change Jeff P Excel Worksheet Functions 2 November 1st 04 09:28 PM


All times are GMT +1. The time now is 01:06 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017