How to change a specified cell value or color when checkbox is checked in Excel?

It is quite simple to get disoriented in Excel if you are working with a huge amount of intricate data at the same time. Step 1 Users may construct spreadsheets at any level, from the most fundamental to the most complicated, thanks to the many capabilities included in Microsoft Excel. This makes users' work life simpler.

a checkbox that allows for the altering of the value or colour of a particular cell. For instance, the value of a certain cell or the colour of its background will be altered automatically if a particular checkbox is selected to be ticked.

Step 1

Consider the following scenario: you want cell A2 to have the value "Test" whenever the first checkbox is selected. In addition, you should clear the cell before unchecking the box.

Navigate to the Developer tool on your browser. Select the Insert menu, then pick the Tick Mark option from the menu that appears.

Step 2

To choose the checkbox, you must select the cell that displays it.

Step 3

To associate the checkbox with a specific cell, kindly select the checkbox, then type "= cell reference" into the Formula Bar, and finally, hit the Enter key on your keyboard. After choosing the checkbox, I then entered =D2 into the Formula Bar of the worksheet to create a connection between the checkbox and cell D2.

Step 4

If you checked the checkbox, then the value in D2 is appearing as TRUE.

Step 5

If you unchecked the checkbox, then the value in D2 is appearing as FALSE.

Step 6

Select the cell in which the value of which needs to be modified here. I start by selecting cell A2 and then typing a formula this into Formula Bar before hitting the Enter key.

=IF(D2,"Test","")

Step 7

If you checked the checkbox, then it will indicate that it is TRUE in cell D2, and the "Test" will appear in cell A2.

Step 8

Select cell A2 that is displaying the test value, go to the Home tab, click on the Conditional Formatting button, and then choose New Rule from the drop-down menu.

Step 9

In "New Formatting Rule" pop up papering , click on "Use a formula to determine which cell to format" and put cell that in to "Edit Rule Description " then click "Format..".

Step 10

Navigate to the "Fill" section, choose the colour, and then click the "ok" button.

Step 11

After doing all possible modification, click the OK button.

Step 12

If you checked the checkbox, then it will indicate that it is TRUE in cell D2, and the colour box  will appear in cell A2.

Step 13

If you unchecked the checkbox, then it will indicate that it is FALSE in cell D2, and the blank box  will appear in cell A2.

Conclusion

In this tutorial, we used a simple example to demonstrate how you can change a specified cell value or color when a checkbox is checked in Excel.