Have you ever ever thought-about utilizing Google Sheets to carry out the next motion: clicking on a checkbox causes your entire row to turn out to be highlighted in a shade of your alternative? This may be extraordinarily helpful for marking particular duties as accomplished.
Here’s a step-by-step information on learn how to obtain this.
Step 1
First, be sure you have checkboxes in your sheet. If not, you’ll be able to add them by clicking the cell the place you desire a checkbox, then going to “Insert” within the prime menu and deciding on “Checkbox.”
Step 2
Upon getting your checkboxes arrange, you’ll be able to create a brand new conditional formatting rule. To do that, click on on “Format” within the prime menu, then choose “Conditional formatting.“
Step 3
Within the conditional formatting panel that opens on the appropriate facet, beneath the “Format cells if” drop-down, choose “Customized method is.“
Step 4
Within the discipline under, enter a method that references the cell with the checkbox. In case your checkbox is in column A and also you need to apply this to the entire sheet, you’d write =$A1=True. The greenback signal ($) earlier than A makes the column absolute, so it received’t shift when utilized to the entire row, and 1 needs to be the primary row variety of your knowledge vary.
Step 5
After coming into the method, choose the formatting model you need to apply when the checkbox is checked. You may set the background shade, textual content shade, and extra. On this case, we’ll change the background shade to inexperienced, as an achieved activity is often related to the inexperienced shade.
Step 6
Lastly, beneath “Apply to vary“, enter the vary the place you need this rule to use.
If you need it to use to your entire row, simply click on on the row quantity on the left and your entire row shall be chosen.
Step 7
Click on “Finished” to use the rule. Right here’s what it seems like whenever you click on on the checkbox.
