Highlighting a cell if the a series of numbers does not add to the same value.

[Pablo78]

Hello, I am making a schedule for a project I am working on. Basically I have some fixed time durations that cannot change. Column A in the below example from column C onwards I will be adding hours on a week by week basis that should add up to 240 per week. I'd like to know If I can format the budgeted hours if the the total placed in the corresponding row does not match the value in column A. Example in A7, the calculation across row B7 - K7 does not meet the criteria. If the criteria is not met then the cell would conditional formatting to highlight there is an issue. This is a pretty big spreadsheet so it can easily go wrong. This would be a good validation method for me to ensure the criteria is met.

Budgeted Labor Hours	Total Resources	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17
39944.84	29
1843.24	3
1843.24	3
1843.24	3	139.628	240	240	0	0	0	0	0	0
112.04	0	112.038
66.24	#DIV/0!	53.24
9.20	#DIV/0!	9.2
26.00	#DIV/0!	26
1.25	#DIV/0!	1.25
1.25	#DIV/0!	1.25
0.50	#DIV/0!	0.5
1.69	#DIV/0!	1.69
3.50	#DIV/0!	3.5
0.80	#DIV/0!	0.8
1.44	#DIV/0!	1.44
0.17	#DIV/0!	0.168
430.61	1	8.19	240	182.267	0	0	0	0	0	0

 

[Pablo78]

I ran out of time to edit my previous post and the example didn't work as I expected. Below is a better explanation of what I am trying to achieve.

Basically I have some fixed time durations that cannot change. Column A in the below example from column C onwards I will be adding hours on a week by week basis. I'd like to know If I can format the budgeted hours if the the total placed in the corresponding row does not match the value in column A. Example in A3, the calculation across row B7 - K7 does not meet the criteria. If the criteria is not met then the cell would conditional formatting to highlight there is an issue. This is a pretty big spreadsheet so it can easily go wrong. This would be a good validation method for me to ensure the criteria is met.

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
1	Budgeted Hours	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17
2	110.43	110.43
3	66.24	9.57	32
4	9.2		9.2
5	26.00		26.00
6	1.25		1.25
7	0.50		0.50
8	1.69		1.69
9	3.50		3.50
10	0.80		0.80