Conditionally Formatting Based on True/False Value

[BrianExcel]

How would I write a formula (non-vba please) that says:

If the sum of B4+B5>15, then display as red text OR if the sum of B4+B5<=15 then display as green text

???

 

[Oaktree]

Are you looking to change the font color of B4 & B5? Or, do you have e.g. B6 = B4+B5 and you're looking to change the font color of B6?

 

[Cease]

If you are using excel 2007 or 2010 from the Home Tab you can choose the conditional formatting and set up a new rule.

From there you can choose to "Use a formula to determine which cells to format", then use
=if(b4+b5>15,true,false)
then have the format set to Red text (or a red box if you want, the options are pretty deep).

Then you'd have to set up a second conditional format
=if(b4+b5<=15,true,false)

Hope this helps :D

 

[BrianExcel]

It's a pain, but I actually just wound up doing two conditional formats for the coloring. The value I want to base the condition on is cell B6, so I basically said

if the value is > B5, then red. Else green.

Thanks!

 

[T. Valko]

If you are using excel 2007 or 2010 from the Home Tab you can choose the conditional formatting and set up a new rule.

From there you can choose to "Use a formula to determine which cells to format", then use
=if(b4+b5>15,true,false)
then have the format set to Red text (or a red box if you want, the options are pretty deep).

Then you'd have to set up a second conditional format
=if(b4+b5<=15,true,false)

Hope this helps :D

You can reduce those formulas to:

=B4+B5>15

=B4+B5<=15

However, you might need/want to account for empty cells!

 

[BrianExcel]

Thanks all!