View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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