I need a formula to highlight a cell if all of a selected group of checkboxes have been clicked. but only if they have all been clicked. my workbook is a detailed checklist of items that must be done on a construction site. once all boxes have been selected (signifying that the work has been checked entirely) the Title cell will be highlighted green.
So far i have only been able to create a formula that works for 1 or 2 checkboxes but that doesnt do me any good. i only want the title to be highlighted green once all checkboxes have been selected. I hope this makes sense. thanks