I don't like check boxes for just this reason, they hover above the cell and are difficult to use in Conditional Formatting.
Here's what I did. I selected each check box and went to its properties and "cell Link" and put in $C$5 (for the first one). I think this has to be done one at a time or maybe someone can develop a macro.
Then I selected C5:C8 and formatted the font to be white (aka invisible)
Conditional Formatting: Selected A5:B8: New Rule> Use Formula
formatted cell as desired.
See Attachment
Bookmarks