excel xp IF function

[WENWEN]

I need help in microsoft excel formula,

I want to use the IF function and the result is in different colour

For example:

A1= 5 B1=5 C1=5

IF the total in A1+B1+C1 = more than 10 the SUM result will appear in black colour BUT if the total of A1+B1+C1 is BELOW 10 the SUM result will be shown in red colour


Please help me what the formula should be
Thanks

[dustyrider]

Select the cell or cells that you want to change the color in. Go to format/conditional formatting & (eg. tell it if it is "less than" 15 & click the "format" button & select the color red). Click OK. Do it again & tell it if it is greater than 15 & select black (under the format button).