How to change text/font colour, using formula

[Maulwy]

Dear All,

Case 1:
A1 + B1 = C1
Condition, if A1 + B1 > 50, result must be in red color, ex= 51 (with red
color)
If A1 + B 1 < 50, result must be in blue color, ex= 49 (with blue color).
In MS Excell, could it happen? Using a formula in ms Excell? Not change
manually....

Thanks in advance...
Maul

 

[Jacob Skaria]

You can using Conditional Formatting

1. Select the cell C1

2. From menu Format>Conditional Formatting>

3. For Condition1>'Cell value Is' select 'Greater than' and enter 50
Click Format Button>Pattern and select your color (say Red)

4. Click on Add button.

5. For Condition2>'Cell value Is' select 'less than' and enter 50
Click Format Button>Pattern and select your color (say Blue)

6. Hit OK

If this post helps click Yes

 

[T. Valko]

You can do this with conditional formatting...

However, you're *excluding* 50 from the test:

if A1 + B1 > 50 red color
If A1 + B 1 < 50 blue color

What should happen if/when A1 + B1 = 50