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

Поділитися
Вставка
  • Опубліковано 25 сер 2024

КОМЕНТАРІ • 95

  • @PresentationProcess
    @PresentationProcess  2 роки тому +1

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

  • @LucineHayrapetyan
    @LucineHayrapetyan 3 роки тому +4

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

  • @SarahSever
    @SarahSever 3 роки тому +2

    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!

  • @mzmonzi6
    @mzmonzi6 2 роки тому

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

  • @kerrydebruyne1923
    @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

  • @irenecaminiti869
    @irenecaminiti869 2 місяці тому +1

    Thank you! This has helped :)

  • @aquarianfebruary7797
    @aquarianfebruary7797 3 роки тому +1

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

  • @hustlehardlex3656
    @hustlehardlex3656 2 роки тому

    best video hands down. looked like magic

  • @LexyLexer
    @LexyLexer Рік тому +1

    AMAZING. THANK YOU SO MUCH

  • @teet-traveleatentertainmenttec
    @teet-traveleatentertainmenttec 2 роки тому +1

    Thank's for the tutorial.

  • @sangeetashrivastava5491
    @sangeetashrivastava5491 Рік тому +1

    You explained very well! Really helpful.

  • @mar4elo999
    @mar4elo999 2 роки тому +1

    very useful video, thank you very much sir!

  • @vandanapatel7741
    @vandanapatel7741 3 роки тому +2

    This is amazing! Super helpful and very clear instruction.

  • @user-rq3wf1zy6s
    @user-rq3wf1zy6s 9 місяців тому

    Hugely helpful! thank you!!!

  • @gurnoorkaur3471
    @gurnoorkaur3471 Рік тому +1

    You explained very well! Really helpful. 🙂

  • @sdfranfraz
    @sdfranfraz 2 роки тому +1

    THANK YOU!!

  • @rajeshbe2234
    @rajeshbe2234 2 роки тому

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

  • @ajaygovinds
    @ajaygovinds 2 роки тому +1

    Just saying...this was awesome 🙌

  • @moelmakrani7116
    @moelmakrani7116 2 роки тому

    You are a great teacher, man! Good job!

  • @radhika5545
    @radhika5545 3 роки тому

    No words for your explanation 👍👍👍👍

  • @TheLuvkat07
    @TheLuvkat07 4 роки тому +1

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

  • @servantofallah8544
    @servantofallah8544 2 роки тому

    As Always Indian, Thank you!

  • @drabdulbasit166
    @drabdulbasit166 5 років тому +2

    superb information. thank you very much

    • @PresentationProcess
      @PresentationProcess  5 років тому

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

  • @Vicky32334
    @Vicky32334 3 роки тому

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

  • @labanmsoffe9252
    @labanmsoffe9252 4 роки тому

    Thank you sir for this informative video. From Tanzania!

  • @aprilaves7309
    @aprilaves7309 Рік тому

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

  • @ilovesharonba
    @ilovesharonba 3 роки тому

    thank you big time, Ramgopal

  • @MrAldinis
    @MrAldinis 3 роки тому

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

  • @lanacahe
    @lanacahe 9 місяців тому

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

  • @rajkonline
    @rajkonline 4 роки тому +1

    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.

  • @rajendran007able
    @rajendran007able 2 роки тому

    SUPER EXPLANATION SIR

  • @anasmamlouk
    @anasmamlouk 2 роки тому

    Thank you , exactly what i needed and well explained

  • @ayshaalnoaimi4444
    @ayshaalnoaimi4444 2 роки тому

    Thank you that was very simple and helpful.

  • @jillymax24
    @jillymax24 2 роки тому

    Very useful, thanks alot!!

  • @BeWorded
    @BeWorded 4 роки тому

    Thnaks for this video. It's very informative!

  • @patrickmadziar3860
    @patrickmadziar3860 4 роки тому

    Thank you. This is very useful information.

  • @beylladiyan9418
    @beylladiyan9418 3 роки тому

    Thanks & very helpful

  • @K-Kratos
    @K-Kratos 3 роки тому +1

    thank you 💗

  • @anoukschaafflood5578
    @anoukschaafflood5578 3 роки тому

    Thank you so much. This was very helpful!

  • @manjunathyh9688
    @manjunathyh9688 2 роки тому

    very helpful i loved it....

  • @michaelothman3704
    @michaelothman3704 2 роки тому

    This is cool and thank you

  • @justynaherbut2724
    @justynaherbut2724 9 місяців тому

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

  • @KisakiNeko
    @KisakiNeko 4 роки тому

    Really helped me with my data tagging problem. Thank youuu

  • @hanyfalata4195
    @hanyfalata4195 4 роки тому +2

    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,

  • @iam.Ravi24
    @iam.Ravi24 3 роки тому

    Nicely explained 👍

  • @Msumudunilanka
    @Msumudunilanka 2 роки тому

    Good video

  • @gcfirestorm12
    @gcfirestorm12 3 роки тому

    Thank you very much

  • @princesssharma2829
    @princesssharma2829 3 роки тому

    Thank you so much sir

  • @chemistrybadi
    @chemistrybadi 5 років тому +1

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

  • @fairuzabubakar2959
    @fairuzabubakar2959 4 роки тому

    very helpful. thanks!

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 роки тому

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

  • @mrityunjoysaha735
    @mrityunjoysaha735 4 роки тому +2

    Nice teaching way.. I like it

  • @natarajang6125
    @natarajang6125 2 роки тому

    Amazing 🙏

  • @nayefkaddoura6308
    @nayefkaddoura6308 3 роки тому

    Thankkk youu alot

  • @19761999
    @19761999 3 роки тому

    Well done, thank you sir.

  • @sohamsaha5370
    @sohamsaha5370 3 роки тому

    Thank you sir..🙏

  • @abiharvey4984
    @abiharvey4984 4 роки тому

    Very helpful - thank you!

  • @temn2235
    @temn2235 4 роки тому

    Thank you so much, Sir
    🙏🙏🙏

  • @SeikoSKO
    @SeikoSKO 3 роки тому

    Great, thank you. help me out

  • @TawnyafromMcKenzieQuinn
    @TawnyafromMcKenzieQuinn 4 роки тому

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

  • @scottpowell1867
    @scottpowell1867 6 місяців тому

    Are able to do the same thing in Microsoft Word?

  • @ionica.iulian
    @ionica.iulian 11 місяців тому

    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 ?

  • @bossg.2073
    @bossg.2073 2 роки тому

    How about the color of the text on dropdown list?

  • @luayalkhalifah3751
    @luayalkhalifah3751 4 роки тому

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

  • @jungleids3625
    @jungleids3625 4 роки тому +1

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

  • @kasem1977
    @kasem1977 4 роки тому

    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.

  • @mukundpanda392
    @mukundpanda392 5 років тому +1

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

    • @PresentationProcess
      @PresentationProcess  5 років тому +1

      Thanks for the suggestion Mukund!

    • @mukundpanda392
      @mukundpanda392 5 років тому

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

  • @mosntergirlygal
    @mosntergirlygal 2 роки тому

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

  • @viktoriakireeva5860
    @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?

  • @ramdanirizkipratama3385
    @ramdanirizkipratama3385 Рік тому

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

  • @fatennassar790
    @fatennassar790 3 роки тому

    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

  • @irmahersel409
    @irmahersel409 2 роки тому

    How do i do the entire row?

  • @prashantkathade8717
    @prashantkathade8717 5 років тому

    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?

  • @digikaininja5
    @digikaininja5 2 роки тому

    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
    @gabyfernandes6334 3 роки тому

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

  • @lovergirl4837
    @lovergirl4837 3 роки тому

    Where is I Button in your video?

  • @rcnethreshgowda6347
    @rcnethreshgowda6347 4 роки тому

    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

  • @chinnu717
    @chinnu717 3 роки тому

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

  • @hmsk3991
    @hmsk3991 3 роки тому

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

  • @ekramulkhan700
    @ekramulkhan700 3 роки тому

    Ekri

  • @sumantadutta4900
    @sumantadutta4900 4 роки тому

    Content not matched with thumbnail

  • @mitchellwilson3033
    @mitchellwilson3033 4 роки тому

    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

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 роки тому

    Plzzzzzzz Sir

  • @georgiaolivia3761
    @georgiaolivia3761 4 роки тому

    Doesn’t work

  • @sumantadutta4900
    @sumantadutta4900 4 роки тому +1

    Faltu