2011-06-30, 12:46 AM
Yeah, I managed to get all of the true/false stuff on my own, but I'm hoping there's a way to mass assign check boxes to cells. Having to individually format each is a real pain
So I'll have my checkbox in, let's say, B2
Then it's formatted so True (if checked) False (if clear) appears in C2. Then in D2 I have =IF(C2,1,0)
The, assuming I have checkboxes from B2 to B10, I would have them formatted equally to C10 and D10
Then in B11 I put =SUM(D2
10)&" /8" which shows an active tally of however many boxes are checked off.
Right now my issue is that each checkbox needs to be indivually correlated to a C cell. I can use the corner-drag formatting for the D cells but that doesn't work for the C cells or they all attach to a single check box. Any way around this?
(so if I put checkboxes in B2:B10, then formatted B2 to C2, if I dragged C2 to C10, checking B2 would make C2:10 true while all of the other boxes would remain unchecked/unassigned)
So I'll have my checkbox in, let's say, B2
Then it's formatted so True (if checked) False (if clear) appears in C2. Then in D2 I have =IF(C2,1,0)
The, assuming I have checkboxes from B2 to B10, I would have them formatted equally to C10 and D10
Then in B11 I put =SUM(D2
10)&" /8" which shows an active tally of however many boxes are checked off.Right now my issue is that each checkbox needs to be indivually correlated to a C cell. I can use the corner-drag formatting for the D cells but that doesn't work for the C cells or they all attach to a single check box. Any way around this?
(so if I put checkboxes in B2:B10, then formatted B2 to C2, if I dragged C2 to C10, checking B2 would make C2:10 true while all of the other boxes would remain unchecked/unassigned)