[SOLVED] Want to shade cell when checkbox is checked

I have with help figured out how to link a check box to a cell and using an array formula subtract total when a check box is checked or add that total back if it is unchecked. As you can see from the Attachment. This was done by "Richard Buttrey" Thanks again for putting me on the right track for this formula and solution. This was the perfect way to solve my problem as I cannot code in VBA so macros are beyond me. My question now, Is there a way to have the cell containing the check box and amount, to shade itself another color when the check box is checked. Then change back when the check box is unchecked.

Thank you in advance for all the help, as I learn new concepts with Excel I appreciate the program even more.

Create a name range as "CheckBoxResult" for data Range "$B$4:$B$7 of Sheet2
next
select the range from $B$4:$B$7 of Sheet1
In conditional format Select "Use a formula to determine which cells to format" from Select a Rule type
then copy the below formula in Edit the rule description
=INDEX(CheckBoxResult,ROWS($B$4:$B4))=TRUE
then format the cell with liked color

See attached,

Please Login or Register  to view this content.