Forum Discussion
Solved
Selecting a fill colour for a cell when a check box is ticked
This is my first post so please forgive me if my problem is very basic. I'd like to have a cell highlighted with a fill colour when its check box is selected. I've got as far as Rules in Conditional Formatting but can't detect any value change in the cell when the box is ticked to trigger the rule with. What should I do?
You have to link the check box to the cell.
If it is a Form Control check box, right-click the check box and select Format Control... from the context menu.
Click in the Cell link box and either point to the relevant cell or type its address, then click OK.
If it is an ActiveX check box, turn on Design Mode on the Developer tab of the ribbon, right-click the check box, then select Properties from the context menu.
Enter the address of the relevant cell in the LinkedCell property, then switch back to Excel and turn off Design Mode.
The value of the linked cell will be either TRUE or FALSE. You can use this in your conditional formatting rule.
You have to link the check box to the cell.
If it is a Form Control check box, right-click the check box and select Format Control... from the context menu.
Click in the Cell link box and either point to the relevant cell or type its address, then click OK.
If it is an ActiveX check box, turn on Design Mode on the Developer tab of the ribbon, right-click the check box, then select Properties from the context menu.
Enter the address of the relevant cell in the LinkedCell property, then switch back to Excel and turn off Design Mode.
The value of the linked cell will be either TRUE or FALSE. You can use this in your conditional formatting rule.
Many thanks HansVogelaar. You have solved my problem!
