How to change text/font colour, using formula

M

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
 
J

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top