Hey guys,
I have a checklist sheet that I was making and there are groups of 10 tasks under a major heading. There is a checkbox to the right of all 11 rows. I wanted to check the box and turn that cell green if it's checked and then be red if unchecked. If you checked the major heading row it would check all of the boxes in that group (all 11) and turn them all green. Then if you check any single box it would update another field for the % complete.
Does anyone have any experience doing something like this? I've been playing around with it but I haven't been successful in getting it working. I've been trying things like adding a macro to each check box and then having it add 2% to the '%complete' cell because there are 50 tasks in total, but this hasn't been working properly and seems prone to failure since it will break the formula if you add a new task to the sheet.
Anyone have any ideas about how to accomplish this in Excel for Mac?
I have a checklist sheet that I was making and there are groups of 10 tasks under a major heading. There is a checkbox to the right of all 11 rows. I wanted to check the box and turn that cell green if it's checked and then be red if unchecked. If you checked the major heading row it would check all of the boxes in that group (all 11) and turn them all green. Then if you check any single box it would update another field for the % complete.
Does anyone have any experience doing something like this? I've been playing around with it but I haven't been successful in getting it working. I've been trying things like adding a macro to each check box and then having it add 2% to the '%complete' cell because there are 50 tasks in total, but this hasn't been working properly and seems prone to failure since it will break the formula if you add a new task to the sheet.
Anyone have any ideas about how to accomplish this in Excel for Mac?
Hey guys,
I have a checklist sheet that I was making and there are groups of 10 tasks under a major heading. There is a checkbox to the right of all 11 rows. I wanted to check the box and turn that cell green if it's checked and then be red if unchecked. If you checked the major heading row it would check all of the boxes in that group (all 11) and turn them all green. Then if you check any single box it would update another field for the % complete.
Does anyone have any experience doing something like this? I've been playing around with it but I haven't been successful in getting it working. I've been trying things like adding a macro to each check box and then having it add 2% to the '%complete' cell because there are 50 tasks in total, but this hasn't been working properly and seems prone to failure since it will break the formula if you add a new task to the sheet.
Anyone have any ideas about how to accomplish this in Excel for Mac?
I have a checklist sheet that I was making and there are groups of 10 tasks under a major heading. There is a checkbox to the right of all 11 rows. I wanted to check the box and turn that cell green if it's checked and then be red if unchecked. If you checked the major heading row it would check all of the boxes in that group (all 11) and turn them all green. Then if you check any single box it would update another field for the % complete.
Does anyone have any experience doing something like this? I've been playing around with it but I haven't been successful in getting it working. I've been trying things like adding a macro to each check box and then having it add 2% to the '%complete' cell because there are 50 tasks in total, but this hasn't been working properly and seems prone to failure since it will break the formula if you add a new task to the sheet.
Anyone have any ideas about how to accomplish this in Excel for Mac?
Aug 28, 2011 Next, we need a text box. Form the Insert menu choose Textbox. Drag diagonally on the worksheet to make a text box. While the textbox is selected, click in the Formula Bar and type this equation =TheTotal The text box now has the total, and it is linked to cell D5. Go ahead and change the values in the table and the text box will update.