[ad_1]
Have you ever ever thought of utilizing Google Sheets to carry out the next motion: clicking on a checkbox causes your complete row to turn out to be highlighted in a coloration of your selection? This may be extraordinarily helpful for marking particular duties as accomplished.
Here’s a step-by-step information on methods to obtain this.
Step 1
First, be sure you have checkboxes in your sheet. If not, you may add them by clicking the cell the place you need a checkbox, then going to “Insert” within the prime menu and choosing “Checkbox.”
Step 2
Upon getting your checkboxes arrange, you may 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 suitable facet, beneath the “Format cells if” drop-down, choose “Customized system is.“
Step 4
Within the subject under, enter a system that references the cell with the checkbox. In case your checkbox is in column A and also you wish 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 must be the primary row variety of your information vary.
Step 5
After getting into the system, choose the formatting type you wish to apply when the checkbox is checked. You possibly can set the background coloration, textual content coloration, and extra. On this case, we’ll change the background coloration to inexperienced, as an completed job is normally related to the inexperienced coloration.
Step 6
Lastly, beneath “Apply to vary“, enter the vary the place you need this rule to use.
In order for you it to use to your complete row, simply click on on the row quantity on the left and your complete row might be chosen.
Step 7
Click on “Accomplished” to use the rule. Right here’s what it seems to be like if you click on on the checkbox.
[ad_2]
