Copy and Paste Data Validation

[tobysdhc]

Hello,

I have a data validation set up from a range of cells by formula SUM($B$2:$G$2)<=1. In other words, I want an error message to show up if the total for cell B2:G2 is greater than 1.

Is there an easy way to apply this to B3:G3 all the way down to B166:G166 without having to do it one at a time?

Thanks in advance,

 

[AlanY]

change it to SUM($B2:$G2)<=1

and copy paste data validation to other cells

 

[tobysdhc]

change it to SUM($B2:$G2)<=1

and copy paste data validation to other cells

Thank you for your response. Unfortunatlly, it does not seem to be working. See the screen shots below. It is not allowing me to enter any value into B2:G2

 

[Fluff]

You need the = sign at the beginning.

 

[AlanY]

Col H will show False if >1

Book1
	A	B	C	D	E	F	G	H	I
1
2		0.113061	0.106134	0.223378	0.041498	0.081748	0.044278	FALSE
3		0.421648	0.176001	0.264953	0.001458	0.148245	0.091921	TRUE
4		0.087513	0.039667	0.443457	0.107691	0.166069	0.014329	FALSE
5		0.439937	0.302879	0.087513	0.078173	0.033718	0.287076	TRUE
6		0.046806	0.215434	0.027721	0.118776	0.326759	0.028908	FALSE
7		0.006114	0.106973	0.006713	0.019592	0.193554	0.348046	FALSE
8		0.186198	0.185583	0.32493	0.025132	0.297417	0.172962	TRUE
9		0.144733	0.054094	0.476407	0.040435	0.03719	0.06623	FALSE
10		0.211114	0.23824	0.320825	0.02598	0.04407	0.151016	FALSE
11		0.373214	0.011308	0.161327	0.261291	0.099189	0.052424	FALSE
12		0.150823	0.278661	0.19587	0.172849	0.260758	0.069321	TRUE
13		0.02208	0.233767	0.085014	0.164622	0.006483	0.027189	FALSE
14		0.322802	0.037117	0.240649	0.318315	0.216474	0.020143	TRUE
15		0.064127	0.27688	0.153225	0.179994	0.181151	0.07001	FALSE
16		0.036439	0.226882	0.091898	0.263556	0.077589	0.234581	FALSE
17
Sheet2

Cell Formulas
Range	Formula
H2:H16	H2	=SUM(B2:G2)>1

 

[tobysdhc]

You need the = sign at the beginning.

Oh boy. I sure do. Thank you, that did the trick!

 

[Fluff]

Glad we could help & thanks for the feedback.