Тёмный

Excel Drop Down List Including Cell Colour Change 

ExcelWithMark
Подписаться 16 тыс.
Просмотров 95 тыс.
50% 1

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

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@excelwithmark
@excelwithmark 3 месяца назад
🙌 SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ 👨‍🏫 FREE Excel Courses: bit.ly/EssentialCourseEWM 🖥 Templates: bit.ly/TemplatesEWM
@snbwz
@snbwz 8 месяцев назад
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
@jasonketelsen 11 месяцев назад
Very helpful... especially the "custom format" that I was missing. Thank you!
@excelwithmark
@excelwithmark 11 месяцев назад
glad that it helps
@MartinMorrisofwythie
@MartinMorrisofwythie 9 месяцев назад
Thanks Mark. Short & sharp, perfect presentation. i have subscribed so hopefully see lots more from you.
@excelwithmark
@excelwithmark 9 месяцев назад
Thank you glad you liked the video and hope you enjoy future content
@rajinidhangar1681
@rajinidhangar1681 2 месяца назад
Thank you, this ended my struggle :D
@mary19462006
@mary19462006 4 месяца назад
Thank you, this video was a life saver :D
@raymond25104
@raymond25104 7 месяцев назад
Thank you so much, sir!
@cliffordrussell50
@cliffordrussell50 6 месяцев назад
Thanks!!!
@markwiltshire8813
@markwiltshire8813 4 месяца назад
Hi Mark, weird question. Where in the UK are you from? Just want to know if I guessed correctly
@excelwithmark
@excelwithmark 4 месяца назад
Im from Yorkshire :)
@matt_solve_this
@matt_solve_this 2 месяца назад
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
@excelwithmark 2 месяца назад
If you highlight the whole list you can use conditional formatting to change the colours of it just the same
@KatrinaDunn-jx7cg
@KatrinaDunn-jx7cg 5 месяцев назад
I’m in love with you
@AsiaThurston-MSDE
@AsiaThurston-MSDE Год назад
Hi Mark, Thank you! My cells aren't changing colors. What can I do?
@excelwithmark
@excelwithmark Год назад
Have you set teh criteria right? Have you made sure its customised to change colour?
@AsiaThurston-MSDE
@AsiaThurston-MSDE Год назад
@@excelwithmark Hi Mark, I figured it out. In my Excel file, I had to choose conditional formatting-->highlight cells rules-->text that contains
@junioranj9297
@junioranj9297 3 месяца назад
it didnt work for me
@antifirizemre
@antifirizemre Месяц назад
👍
Далее
How to Use VLOOKUP in Excel (free file included)
15:15
Просмотров 243 тыс.
Create Dependent Drop Down List in Excel - EASY METHOD
12:10
Advanced Excel - Data Validation and Drop-Down Lists
13:08
Excel Drop Down List Tutorial
8:37
Просмотров 991 тыс.