Trying to configure cell validation without success

[bossman754]

I am using excel 2003, XP Pro. I am trying to create basic math worksheets for my second grader to complete on the computer. An example of what I am trying would be cell a1 value is 5, cell b1 value is 5. So he should be putting 10 for the value in cell c1. I wanted to have the validation of c1 change color or something if he puts in the incorrect value. But I can't make this work. The big question is, is this possible or am I barking up the wrong tree by using excel. Any thoughts on what I'm trying to do would be appreciated. I don't consider myself a pro user of excel but do feel I am a more advanced user. Thanks in advance

 

[acw]

Hi

Select C1 then Format, Conditional Format, Formula Is, =a1+b1 = 10, select your format (say pattern = green), then save


HTH

Tony

 

[Yogi Anand]

I am using excel 2003, XP Pro. I am trying to create basic math worksheets for my second grader to complete on the computer. An example of what I am trying would be cell a1 value is 5, cell b1 value is 5. So he should be putting 10 for the value in cell c1. I wanted to have the validation of c1 change color or something if he puts in the incorrect value. But I can't make this work. The big question is, is this possible or am I barking up the wrong tree by using excel. Any thoughts on what I'm trying to do would be appreciated. I don't consider myself a pro user of excel but do feel I am a more advanced user. Thanks in advance

Hi bossman:

Welcome to MExcel Board!

How about ...

y051130h1.xls
	A	B	C	D
1	5	5	10
2	3	6	8
3	2	3	5
4	4	3	7
5	5	2	7
6	3	5	9
7	4	4
8
Sheet9

I used CF formula in cell C1 ... =AND(C1<>A1+B1,C1<>"") ... pattern Red