Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box = 1
I'm pretty out of my depth here, so any help would be much appreciated.
I'm trying to set up an attendance form to cover a 24 hour perid. i'd like a columnof 14 checkboxes (places available per hour), and at the bottom a total of how many boxes have been checked, and then repeated for the following 23 columns. How do i go about giving a cell the value of "1"if the box is checked, and accumulated the total of checked boxes. I'm struggling to get past changing "true"/"false" values to "1"/"0" values. Also, do i have to do this 2352 seperate times (14 places x 24 hours x 7 days a week), or can i do copy and paste? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box = 1
I hope I understand what you are doing.
How about making the "check" the number 1 and then apply conditional formatting to colour the cell and text the same colour. Counting that would be easy. There are other "count" formulae which would do the job but I have been using a similar method and it also shows graphically how things are progressing. You should only need to do one cell and then copy as much as you need. "Dave" wrote: I'm pretty out of my depth here, so any help would be much appreciated. I'm trying to set up an attendance form to cover a 24 hour perid. i'd like a columnof 14 checkboxes (places available per hour), and at the bottom a total of how many boxes have been checked, and then repeated for the following 23 columns. How do i go about giving a cell the value of "1"if the box is checked, and accumulated the total of checked boxes. I'm struggling to get past changing "true"/"false" values to "1"/"0" values. Also, do i have to do this 2352 seperate times (14 places x 24 hours x 7 days a week), or can i do copy and paste? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the check mark boc bigger on the check box? | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) |