How to change text/font colour, using formula
 

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

How to change text/font colour, using formula
 

You can using Conditional Formatting

1. Select the cell C1

2. From menu FormatConditional Formatting

3. For Condition1'Cell value Is' select 'Greater than' and enter 50
Click Format ButtonPattern 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 ButtonPattern and select your color (say Blue)

6. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Maulwy" wrote:

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

How to change text/font colour, using formula
 

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

--
Biff
Microsoft Excel MVP


"Maulwy" wrote in message
...
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