Forum Discussion
Selecting a fill colour for a cell when a check box is ticked
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!
