I latterly wrote an instructional on including a drop-down listing in Google Sheets. With this straightforward trick, you’ll be able to make it exponentially more straightforward for collaborators to fill in knowledge from a to hand listing of choices (as a substitute of getting to sort the entirety manually). This may additionally save you customers from coming into the flawed knowledge right into a vital box for your spreadsheet.
You’ll use any other nifty trick to help in making those cells stand out as soon as a collaborator has made a piece. That trick is known as Conditional Formatting.
Let’s examine how that is accomplished.
Including conditional formatting to a drop-down listing
Consider, within the instructional for including drop-down lists; we created a listing of the next colours:
We are going to use conditional formatting to set the mobile’s background colour in accordance with the colour selected. So, if a collaborator chooses inexperienced from the drop-down, the mobile background colour shall be set to inexperienced.
1. Open the conditional formatting rule editor
Choose the mobile that comprises the drop-down after which click on Structure > Conditional formatting (Determine 1).
Upon clicking conditional formatting, you can see a brand new sidebar at the proper aspect of the window (Determine 2).
2. Create a brand new conditional formatting rule
Click on + Upload any other rule to open the Rule editor (Determine 3).
You will have to have already got the proper mobile indexed within the vary. From the Structure cells, drop-down, make a selection Textual content comprises. Within the Worth or components space, sort inexperienced after which make a selection the colour inexperienced from the colour picker (Determine 4).
As soon as you’ve gotten decided on the colour, click on Finished, and the guideline is in a position. Proceed to create extra laws till you could have one for every colour for your drop-down.
Now, when a consumer selects a colour from the drop-down, the background colour will robotically exchange in accordance with the situation (Determine 5).
And that, my fellow Google Sheets customers, is the way you upload conditional formatting to a drop-down listing. You might be no longer restricted to drop-downs for this option, as you’ll be able to use it on any form of name (or even a spread of cells). Benefit from the contemporary style of automatic formatting.