Check Boxes not functional

[AllenCochran]

<TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448><COLGROUP><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 width=64>A

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 width=64>B

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 width=64>C

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 width=64>D

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 width=64>E

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 width=64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 align=right>1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl65></TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl66 width=64></TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl67 width=64>Clean</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: blue 0.5pt solid" class=xl67 width=64>Repair</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl68 colSpan=2>ENTRANCE AND FOYER</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 align=right>2</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70 align=right>1</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 width=64>0</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl72 colSpan=2>Advertising POP postings, current and clean</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 align=right>3</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70 align=right>2</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 width=64>0</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: #f0f0f0" class=xl72>Threshold </TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: #f0f0f0" class=xl69></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 align=right>4</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70 align=right>3</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 width=64>0</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl72 colSpan=2>Host/Hostess station </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 align=right>5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70 align=right>4</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 width=64>0</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl72 colSpan=2>Walls and ceiling in foyer clean and attractive</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 align=right>6</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl70 align=right>5</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl66 width=64>0</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: blue; BORDER-RIGHT: blue 0.5pt solid" class=xl71 width=64 align=center>TRUE</TD><TD style="BORDER-BOTTOM: blue 0.5pt solid; BORDER-LEFT: blue 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: blue 0.5pt solid; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl73 colSpan=2>Front Entrance Window </TD></TR></TBODY></TABLE>​

Above is an example. I want cells C2:D6 to be check boxes or some other item that can be toggled and be linked to the same cell. I want column B to = 0 if both C and D are true and B = 1 if either is not true.

I need to have approx. 1000 of these checkboxes. when I did it using form control, the file size became too large to manage.

I think I am making this way to hard on myself.

 

[Steve=True]

For b2

=if(and(c2="True",d2="True"),0,1)

 

[AllenCochran]

I have that part figured out. I am looking to find a check box/toggle button/radio button that the end user can click on that will generate a true or false for the cell.

The Form Control buttons make the spreadsheet to large of a file size to manage.

thanks for your help