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
|