How to Color Code Drop-Down Lists in Google Sheets #shorts

Learn how to create modern, colorful, chip-style looking drop down lists in Google Sheets. Drop-down lists are a great way to simplify data entry by using data validation. You can limit the input to predefined options with different colors. This not only makes it easier to input data but also eliminates spelling errors or the entry of non-existent options.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets

[TP]

That is awesome, excel needs to that ASAP!!

[harshchoksi]

Other You tuber might create separate 10 minutes video but she nailed it in short reels. So, easy to understand.

[nm]

I've been wanting to do this for sooo long!

[timebank]

I'm sure that Microsoft will adapt this feature in the next update of Excel....
They always adapt to stay competitive

[gemajams]

I'm not a fan of sheets it's so limited but this is good to know

[sideshowbobby]

This is great! I wish Google had a version of LET and XLookUp.

[deonwilsonchr]

This is Great I am a huge excel Promoter - I think with List in the Microsoft office portfolio it will not be soon - it is awesome and will make my project planer way better

[hansklein]

You can use it as a spelling check, when you choose the plain text mode.

[Roxxelana]

Is there a way to change the default 'chip' colour? Having to create a coloured placeholder chip is annoying. If they could match the default chip to the sheet colour, that'd be great.

[exclusivelynyc]

I've been using this cool feature. Do you know how to share the same drop down over multiple sheets? I haven't figured it out yet. Thank you

[mcd]

Finally someone at Google coming up with a good idea. Hopefully this isn’t a sign that the Apocalypse is near.

[rokuridia]

I just wish that dependent drop down list could be easier to be done.

[alexmihalache]

Can't you achieve that with conditional formatting?

[philinfogloballtd]

how can one use this feature in a multiple-dependent drop-down list . Any time i try changing one list the first one loses its colors

[sharran]

How can one do the same thing with colors in drop-down on excel

[jpgo]

Which spreadsheet app do use most? Having to cycle multiple applications is getting difficult due to the different features and functions being added which doesn't always work with the other.

[Wzxxx]

U r gorgeous besides that modern lists😂