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.

Step 1

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.”

insert checkboxinsert checkbox
Step 2

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.

Conditional formattingConditional formatting
Step 3

Within the conditional formatting panel that opens at the proper aspect, below the “Structure cells if” drop-down, make a choice “Customized components is.

custom formula is...custom formula is...
Step 4

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.

Step 5

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.

set color and styleset color and style
Step 6

In any case, below “Follow to vary“, input the variety the place you need this rule to use.

apply to rangeapply to range

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.

row selectedrow selected
Step 7

Click on “Accomplished” to use the rule of thumb. Right here’s what it seems like whilst you click on at the checkbox.

checkbox clickedcheckbox clicked

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/

[ continue ]