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

Master fundamentals of Excel with Complete Excel Foundation Course: shop.presentation-process.com/p/complete-excel-foundation-course

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

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!

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

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

You are awesome..Crisp.and clear info. It helped me to do data validation with colour formatting instantly

I learn too much and super helpful for my work, i hope i will learn more bcz i need it in my work

Just saying...this was awesome 🙌

best video hands down. looked like magic

You explained very well! Really helpful.

very useful video, thank you very much sir!

This is amazing! Super helpful and very clear instruction.

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

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.

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,

You explained very well! Really helpful. 🙂

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

AMAZING. THANK YOU SO MUCH

Thank you so much!!!! I have been working on this for an hour!!

Thank's for the tutorial.

No words for your explanation 👍👍👍👍

Thank you sir for this informative video. From Tanzania!

You are a great teacher, man! Good job!

thank you i cried for 30 minutes trying to figure this out

Thanks for that. When I click on 'equal to' I don't get the same simple window prompting to type the word.

Really helped me with my data tagging problem. Thank youuu

superb information. thank you very much

Thank you that was very simple and helpful.

Thank you , exactly what i needed and well explained

thank you big time, Ramgopal

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

Thank you. This is very useful information.

Thank you so much. This was very helpful!

Thnaks for this video. It's very informative!

Hugely helpful! thank you!!!

THANK YOU!!

Xlent information... Sir... That reduced my time.... To make a sheet.... Thank you... 👌👌👌

Thank you! This has helped :)

SUPER EXPLANATION SIR

Thanks & very helpful

Very useful, thanks alot!!

I will be greatfull to u.I am a subscriber of your channel

Nice teaching way.. I like it

As Always Indian, Thank you!

Nicely explained 👍

Well done, thank you sir.

very helpful i loved it....

This is cool and thank you

Thank you so much sir

Thank you very much

I've been searching for days - how to highlight the cell, which is next to the drop-down list, depending on the text in the list. So in this case, how to highlight the Student Name, depending on what grade you choose from the drop-down list?

very helpful. thanks!

thank you 💗

Thank you sir..🙏

Are able to do the same thing in Microsoft Word?

Exactly what I needed to know, plus other useful information. Thank you!

Is there any way to make the color from 'sheet 1' to then match the drop down selection from 'sheet 2'?? TIA!

Very helpful - thank you!

Good job sir. I have one request eg is there any option to change the font size of validation data which shows only click on down arrow. Because cell font size and down arrow font size are not same.

HELLO, how can u add the drop-down list to the column? here it shows if u used the table and they need to click on the tab always. is there another way please to the drop down to all the column

I have two sheets in excel, in the first sheet on cell A2 I have a text and the color are green. I want in the sheet 2 on cell A2 to have the same color green. If I change the color on sheet 1 ex yelow automatically change in the sheet 2 the cell A2 in yellow. I have text not numbers in the cell . Conditional formatting not help me because I don't have numbers, I need something like conditional color, I don't know, can you help me ?

Thank you so much, Sir 🙏🙏🙏

Good video

Amazing 🙏

The "Custom Format" option doesn't show up for me in Microsoft Excel. Is this a new feature? Thank you

Gopal ji, Namaskaram n Greetings. All the old excel sheets when I change the data in the lists, the same doesn't reflect back in the master sheet but it shows me the old data.....if you have understood my query clearly. I don't know how else to phrase it.

How about the color of the text on dropdown list?

Thankkk youu alot

Great, thank you. help me out

Sir already I saw your video on excel speak cell option But now that video is not getting for download, pls help me in getting that video of your channel

Hello Ram Gopal Ji You Can Also Think About MS Word Tutorial Video

Hi GM sir, plz guide on conditional formatting my query is I have an day wise cell data from day 1 to day 15 and 30 sells persons. I want to apply conditional formatting Arrow icon set How to show value is greater than yday in each cell?

if i enter "C" in grade column then it comes automatically "Fail" in Pass/Fail Column. How ???? please answer

Lol 2:54 Ram got A grade but he got failed 😂

how to keep the color, but we would like to add text

Where is I Button in your video?

Thank you so much for your Video, it is really helpful.

How do i do the entire row?

The part of extend the table and data validation isn’t available Repeat explanation clearly something wrong i did repeated the video 3 times

Content not matched with thumbnail

the drop down lost itself has no color at any time. misleading title, this is just regular conditional formatting, data validation list remains black and white

Ekri

Doesn’t work

Plzzzzzzz Sir

Faltu