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

[@PresentationProcess]

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

[@LucineHayrapetyan]

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

[@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!

[@kerrydebruyne1923]

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

[@ajaygovinds]

Just saying...this was awesome 🙌

[@PresentationProcess]

Many thanks for sharing

[@hustlehardlex3656]

best video hands down. looked like magic

[@mzmonzi6]

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

[@aquarianfebruary7797]

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

[@PresentationProcess]

Glad to hear that

[@hanyfalata4195]

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,

[@teet-traveleatentertainmenttec]

Thank's for the tutorial.

[@LexyLexer]

AMAZING. THANK YOU SO MUCH

[@KerryLittle-l4z]

Hugely helpful! thank you!!!

[@sangeetashrivastava5491]

You explained very well! Really helpful.

[@PresentationProcess]

Glad it was helpful!

[@mar4elo999]

very useful video, thank you very much sir!

[@justynaherbut2724]

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

[@ilovesharonba]

thank you big time, Ramgopal

[@moelmakrani7116]

You are a great teacher, man! Good job!

[@rajeshbe2234]

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

[@radhika5545]

No words for your explanation 👍👍👍👍

[@gurnoorkaur3471]

You explained very well! Really helpful. 🙂

[@sdfranfraz]

THANK YOU!!

[@vandanapatel7741]

This is amazing! Super helpful and very clear instruction.

[@aprilaves7309]

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

[@Vicky32334]

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

[@irenecaminiti869]

Thank you! This has helped :)

[@PresentationProcess]

You're welcome!

[@MrAldinis]

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

[@lanacahe]

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

[@TheLuvkat07]

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

[@jillymax24]

Very useful, thanks alot!!

[@iam.Ravi24]

Nicely explained 👍

[@labanmsoffe9252]

Thank you sir for this informative video. From Tanzania!

[@rajendran007able]

SUPER EXPLANATION SIR

[@beylladiyan9418]

Thanks & very helpful

[@ayshaalnoaimi4444]

Thank you that was very simple and helpful.

[@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.

[@patrickmadziar3860]

Thank you. This is very useful information.

[@BeWorded]

Thnaks for this video. It's very informative!

[@anasmamlouk]

Thank you , exactly what i needed and well explained

[@drabdulbasit166]

superb information. thank you very much

[@PresentationProcess]

Thank you for watching the video and commenting! Nice to know it was helpful.

[@waqasarshad7904]

@Presentation Process I am working to create an excel sheet for a specific purpose mainly covering some business details for me. Your video's topic may also be helpful for me, but I have another query. Can you please help me out? I have hardly found anything close so far. For some entries in cells, I have used data validation (selected 'List' as validation criteria under 'Allow' tab of Data Validation window) for three options. In addition to that, I have used Conditional Formatting, made a New Rule by selecting 'Use a formula to determine which cells to format' and used 'Format' button to fill the colors of cells. The purpose is to identify the cells based on outcome and color of the formatted cell (e.g. Excellent, Good, Poor as three options in drop-down of a single cell). For the purpose of sharing the information to other, I want to add the comments with each of the drop-down option. Is there a way that can be helpful to auto-populate separate comment based on drop-down selection of data validation options of a single cell?

[@mosntergirlygal]

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

[@K-Kratos]

thank you 💗

[@PresentationProcess]

You're welcome 😊

[@manjunathyh9688]

very helpful i loved it....

[@KisakiNeko]

Really helped me with my data tagging problem. Thank youuu

[@michaelothman3704]

This is cool and thank you

[@anoukschaafflood5578]

Thank you so much. This was very helpful!

[@chemistrybadi]

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

[@PresentationProcess]

That's great!

[@mahaboobhossain5076]

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

[@kasem1977]

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.

[@scottpowell1867]

Are able to do the same thing in Microsoft Word?

[@mrityunjoysaha735]

Nice teaching way.. I like it

[@fatennassar790]

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

[@princesssharma2829]

Thank you so much sir

[@ionica.iulian]

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 ?

[@gcfirestorm12]

Thank you very much

[@natarajang6125]

Amazing 🙏

[@fairuzabubakar2959]

very helpful. thanks!

[@nayefkaddoura6308]

Thankkk youu alot

[@sohamsaha5370]

Thank you sir..🙏

[@bossg.2073]

How about the color of the text on dropdown list?

[@prashantkathade8717]

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?

[@19761999]

Well done, thank you sir.

[@rcnethreshgowda6347]

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

[@GeminisArising888]

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.

[@gabyfernandes6334]

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

[@servantofallah8544]

As Always Indian, Thank you!

[@abiharvey4984]

Very helpful - thank you!

[@viktoriakireeva5860]

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?

[@mukundpanda392]

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

[@PresentationProcess]

Thanks for the suggestion Mukund!

[@mukundpanda392]

@@PresentationProcess Welcome Again I Would Like To Say I Like Powerpoint Most Rather Than Excel And Word

[@irmahersel409]

How do i do the entire row?

[@temn2235]

Thank you so much, Sir 🙏🙏🙏

[@LittleTeacherT]

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

[@Msumudunilanka]

Good video

[@ramdanirizkipratama3385]

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

[@chinnu717]

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

[@lovergirl4837]

Where is I Button in your video?

[@SeikoSKO]

Great, thank you. help me out

[@luayalkhalifah3751]

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

[@jungleids3625]

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

[@sumantadutta4900]

Content not matched with thumbnail

[@hmsk3991]

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

[@mitchellwilson3033]

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

[@ekramulkhan700]

Ekri

[@georgiaolivia3761]

Doesn’t work

[@DK-ps4xg]

Me too

[@mahaboobhossain5076]

Plzzzzzzz Sir

[@sumantadutta4900]

Faltu