View Single Post
  #3   Report Post  
Old September 27th 07, 08:05 AM posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
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???