Office hacks: check on the color Excel checkboxes can be used in this way

Want to deal with some options in Excel, we often use the check box, the effect is also to tick, fork, although it can be used, but in a large number of processing or display often feel that some are not conspicuous enough, it can also what other look? In fact, as long as you use the functions of Excel controls, you can make the checkbox will change color after the effect.

First of all, you need to set up your own table to make it look more beautiful. Use the left mouse button to drag and drop to circle all items in the table, then click the right mouse button and select “Set Cell Format”.


In the “Format Cells” interface, switch to the “Borders” tab, click the “Outer Borders”, “Inner “two, so that the table has a border and the inner frame, to separate the cells. At the same time, if necessary, you can choose to set the border color.


Settings are completed back to the main interface, the left mouse button drag and drop to circle the need to set the cell, text, such as the author here to set the table header, the cell background color is gray, click Excel above the “Start”, and then select the “theme color”, set to gray.


The default text is black, if the background becomes dark it is not easy to distinguish, then you should set the color of the text part, click the text color button, set to “white” or other light colors can be.


Back to the main Excel interface, at this point we need to enable the ability to add controls, click on “File”, and then select “Options”.


Excel options, first mouse click on the left side of the “Custom Ribbon”, and then on the far right side of the “Custom Ribbon”, scroll down to find the “Development Tools”. Check the box to make it effective.


After setting up, go back to the Excel interface, click the “Development Tools” above, click “Insert”, and then find the “checkbox (form control)” click Add.


Repeat this action to add a checkbox for each of the same category of content in the form, such as the author’s example of the use of the form, a total of four different items, then add four can. Note that the four checkbox controls set, the text descriptions added by default are removed, leaving only the checkbox can be.


At this point, a “TRUE” is added after each row of the table (excluding the header row).


Next, check the checkbox in the first column, then right-click on the checked checkbox control and select “Set control format”


In the “Set Object Format” switch to “Control”, then click “Cell Link”, then click the up arrow icon behind and tap the last of the same row “TRUE” at the end of the same row. Note that each check box should correspond to the same line of “TRUE”, not the wrong line.


If set correctly, when the checkbox is checked to the corresponding line, the back will become “TRUE”, if not checked, it will become “False”, as shown in the figure.


At this point, select the line to check the color change display, and then click Excel above the “Start”, find the “conditional formatting” and select “New Rule”.


In the “Select Format Rule”, click to select the “use the formula to determine the cells to be formatted”, and then click the “format for the value of this formula” behind the arrow icon .


Next, click on the line after the “TRUE” to select the Enter.


Back to just the interface, click the bottom of the “Preview” after the “Format”, switch the tab to the “Fill” item, set the “pattern color “, switch to “Font” to set the text color to white.



Back to the Excel table to try, if the operation is correct, when you check to just set the line, the bottom of the cell color will have substantial changes. If successful, according to this method will need to check the color of the other content set one by one, note that different categories of lines to use different colors to distinguish.


Everything is set, we have to do the last step: click the last column to circle all the content, and then click the right mouse button, select “Hide” on it.


Leave a Comment