Is there a way to group a number of cells to be conditionally formatted based on one check box? I'm trying to create a checklist for specific documentation needed for my job. As you can see in the image, rows 4-7 are independent and easy to format. However I would like to group rows 8-11, 12-16, and 17-20, so when I check the checkbox in row 8, 12, or 17 that the group all becomes highlighted.
Is this possible? and if so what formula would I use?
Thanks!
Bookmarks