I am creating a rather large workbook. I have checkboxes in a couple of different sheets. One particular check box needs to 2 different things to happen.

First, it needs to trigger a Conditional Formatting in another cell. Which I had set-up.

Second, it needs to trigger another checkbox in another cell to be true. This is why I now need to write the VBA.

I am using Office 2010 and the format control checkbox.

I also need to complete these two functions with other checkboxes.

When a checkbox is true (checked) to void/grayout/remove formulas from a series of cells in that sheet

and

When a checkbox is true (checked) I want it to trigger another checkbox to be red until it is also marked as true (checked)