Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have my IF formula, how can i change the text colour for eachif??!! help please!! | Excel Worksheet Functions | |||
formula to change font or cell colour | Excel Worksheet Functions | |||
Change font colour for whole row | Excel Worksheet Functions | |||
Change Font Colour Automatic When Formula Match | Excel Discussion (Misc queries) | |||
font colour change within a IF formula - Help!! | Excel Worksheet Functions |