Create Drop Down List in Excel with Color (Data Validation)

Learn how to create Drop Down List in Excel with color. Add data validation and control the data entered with a drop-down list. This video uses examples to make the set up easy to follow.
This is an alternative way of adding data validation. Creating a dropdown list makes data entry easier.
Sign Up for Complete Excel Foundation Course:

What is covered in this Excel tutorial:
==============
00:00 Introduction
01:45 Add Dropdown List from a separate sheet
02:55 Add Conditional Format based on the data entered
05:25 Converting cells into a Table
06:05 Extend data validation to other cells

#ramgopalexcel

[LucineHayrapetyan]

Dear Ramgopal, thank you infinitely for your simple, straight-to-the-point explanations.
Regards from Armenia

[vandanapatel]

This is amazing! Super helpful and very clear instruction.

[mzmonzi]

Thank you. Such an easy and quick way to learn how to do this without all the unnecessary information

[rajkonline]

This what I was looking for and struglling for a long time. Thanks a lot for such a informative video. Really very good job and thanks for sharing your valuable knowledge.

[SarahSever]

Thank you. Hadn't it been for good titling, I would not have landed on your video as the first choice. Problem solved, have a good looking worksheet/table!

[labanmsoffe]

Thank you sir for this informative video. From Tanzania!

[moelmakrani]

You are a great teacher, man! Good job!

[hanyfalata]

Thank you very much, was very helpful to me.
Do you have a video explaining how to make graphs that automatically changes upon selected cells input? Thanks,

[gurnoorkaur]

You explained very well! Really helpful. 🙂

[anoukschaafflood]

Thank you so much. This was very helpful!

[kerrydebruyne]

This was a really helpful video, I watched a couple before this one which didn't explain it quite so simply. Thanks v much

[Vicky]

Totally cleared, was confused, u made my day bro. Welldone

[pointingtojesus]

Thnaks for this video. It's very informative!

[KisakiNeko]

Really helped me with my data tagging problem. Thank youuu

[anasmamlouk]

Thank you, exactly what i needed and well explained

[ayshaalnoaimi]

Thank you that was very simple and helpful.

[MrAldinis]

Thank you Ram....you go to the point! :)

[patrickmadziar]

Thank you. This is very useful information.

[rajeshbe]

Thank you for this video sir. It's very easy to understand.

[hustlehardlex]

best video hands down. looked like magic