Excel Drop Down List Including Cell Colour Change

Elevate your Excel skills with my comprehensive course and powerful templates. Whether you're a beginner or an advanced user, this is your go-to resource for mastering Excel:
bit.ly/m/excel...
================
Looking for a comprehensive guide on creating and formatting drop-down lists in Excel? Look no further! In this video, we'll show you how to create a dynamic drop-down list in Excel, complete with conditional formatting and cell color changes based on dropdown selections. We'll cover everything from basic drop-down list creation to advanced formatting options, including background color changes and conditional formatting. Whether you're an Excel beginner or an advanced user, this tutorial has something for everyone. So if you want to take your Excel skills to the next level, be sure to watch this video and learn how to create drop-down lists like a pro!
================
Socials:
Instagram : / excelwithmark
TikTok: / excelwithmarkyt

[@excelwithmark]

🙌 SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ 👨‍🏫 FREE Excel Courses: bit.ly/EssentialCourseEWM 🖥 Templates: bit.ly/TemplatesEWM

[@snbwz]

Dude, thank you so much. This is the only method that worked for me! Using whatever the newest Excel you get from Office 365.

[@jasonketelsen]

Very helpful... especially the "custom format" that I was missing. Thank you!

[@excelwithmark]

glad that it helps

[@MartinMorrisofwythie]

Thanks Mark. Short & sharp, perfect presentation. i have subscribed so hopefully see lots more from you.

[@excelwithmark]

Thank you glad you liked the video and hope you enjoy future content

[@mary19462006]

Thank you, this video was a life saver :D

[@rajinidhangar1681]

Thank you, this ended my struggle :D

[@raymond25104]

Thank you so much, sir!

[@cliffordrussell50]

Thanks!!!

[@KatrinaDunn-jx7cg]

I’m in love with you

[@markwiltshire8813]

Hi Mark, weird question. Where in the UK are you from? Just want to know if I guessed correctly

[@excelwithmark]

Im from Yorkshire :)

[@matt_solve_this]

What happens if you have a big list already and want to implement this cell colour change in the whole list, will you have to go to each one or is there a way to handle all the list in multiple cells down a column?

[@excelwithmark]

If you highlight the whole list you can use conditional formatting to change the colours of it just the same

[@user-sx7xp5lw8d]

Hi Mark, Thank you! My cells aren't changing colors. What can I do?

[@excelwithmark]

Have you set teh criteria right? Have you made sure its customised to change colour?

[@user-sx7xp5lw8d]

@@excelwithmark Hi Mark, I figured it out. In my Excel file, I had to choose conditional formatting-->highlight cells rules-->text that contains

[@antifirizemre]

👍

[@junioranj9297]

it didnt work for me