View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maulwy Maulwy is offline
external usenet poster
 
Posts: 10
Default 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