Clicking on Check Box changes Color of another cell in Excel

[nelson97]

Hi,

Working on Excel...I created a color coded sheet where I have Cells with embedded checkboxes and when you click on the checkbox that cell turns a certain color. I would like to add to that functionality whereby if I click on the checkbox it will also change the color of another cell.
For example I have cell D4 set to change Green if you click on the checkbox. I want cell D3 to change cell color to xlnone when D4 is clicked.

Suggestions?

Thank you

 

[DrJavaJoe]

Wrong forum try
VBA Visual Basic for Applications forum707

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.