font color for formula answer

J

Judson

I have 2 columns that when added, must aways have the sum of 12. I have to
look at 1200 of these, and after looking at these for hours at time, I miss a
few. Is there a way I can do a formula that says when two cells added
together, they must = 12 if yes, OK, if not thn No. what I would like it to
do, is the two cells do not add up to 12, either higher or lower, the font
color for "No" is red so it stands out. Thanks for all the help, try to keep
it simple for me, I am no pro
 
B

Bernard Liengme

Assuming numbers in A and B
In C1 enter =IF(A1+B1=12,"OK","NO")
Copy down the column
Select the C entries
Use Format | Conditional Formating
Make dialog read: Celll Value Is .. Equal to ..NO
Click Foramt button and set colour to red
best wishes
 
S

SVC

Use conditional formatting in the cell that contains the result of the formula.

Format > Conditional Formatting, under Condition 1 Cell value is--not equal
to--12, then select Format, and on the Font tab select the color (you can
also Bold it to make is more obvious).
 
Top