View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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