Have you ever ever thought to be the usage of Google Sheets to accomplish the next motion: clicking on a checkbox reasons all the row to change into highlighted in a colour of your selection? This can also be extraordinarily helpful for marking explicit duties as finished.
Here’s a step by step information on how to succeed in this.
First, you’ll want to have checkboxes to your sheet. If no longer, you’ll be able to upload them through clicking the mobile the place you need a checkbox, then going to “Insert” within the best menu and deciding on “Checkbox.”
After getting your checkboxes arrange, you’ll be able to create a brand new conditional formatting rule. To do that, click on on “Structure” within the best menu, then make a choice “Conditional formatting.“
Within the conditional formatting panel that opens at the proper aspect, below the “Structure cells if” drop-down, make a choice “Customized components is.“
Within the box beneath, input a components that references the mobile with the checkbox. In case your checkbox is in column A and you need to use this to the entire sheet, you could possibly write
=$A1=True. The greenback signal (
$) ahead of
A makes the column absolute, so it received’t shift when implemented to the entire row, and
1 will have to be the primary row choice of your information vary.
After coming into the components, make a choice the formatting taste you need to use when the checkbox is checked. You’ll set the background colour, textual content colour, and extra. On this case, we will be able to exchange the background colour to inexperienced, as an completed job is in most cases related to the golf green colour.
In any case, below “Follow to vary“, input the variety the place you need this rule to use.
If you need it to use to all the row, simply click on at the row quantity at the left and all the row will probably be decided on.
Click on “Accomplished” to use the rule of thumb. Right here’s what it seems like whilst you click on at the checkbox.
The submit Methods to Spotlight a Row in Google Sheets In keeping with a Checkbox gave the impression first on Hongkiat.WordPress Website Development Source: https://www.hongkiat.com/blog/google-sheets-click-highlight-row/