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 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,
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.
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.
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 ?
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'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?
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.
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
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?
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
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
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
Glad to hear that
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!
best video hands down. looked like magic
Just saying...this was awesome 🙌
Many thanks for sharing
very useful video, thank you very much sir!
Thank you. Such an easy and quick way to learn how to do this without all the unnecessary information
You explained very well! Really helpful.
Glad it was helpful!
I learn too much and super helpful for my work, i hope i will learn more bcz i need it in my work
Thanks for that. When I click on 'equal to' I don't get the same simple window prompting to type the word.
Thank's for the tutorial.
Thank you for this video sir. It's very easy to understand.
AMAZING. THANK YOU SO MUCH
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,
No words for your explanation 👍👍👍👍
Hugely helpful! thank you!!!
thank you big time, Ramgopal
superb information. thank you very much
Thank you for watching the video and commenting! Nice to know it was helpful.
This is amazing! Super helpful and very clear instruction.
Totally cleared, was confused , u made my day bro. Welldone
You explained very well! Really helpful. 🙂
Thank you Ram....you go to the point! :)
Thank you that was very simple and helpful.
Is there any way to make the color from 'sheet 1' to then match the drop down selection from 'sheet 2'?? TIA!
Thank you. This is very useful information.
Thank you sir for this informative video. From Tanzania!
You are a great teacher, man! Good job!
SUPER EXPLANATION SIR
Thnaks for this video. It's very informative!
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! This has helped :)
You're welcome!
Thank you , exactly what i needed and well explained
Really helped me with my data tagging problem. Thank youuu
Very useful, thanks alot!!
THANK YOU!!
Nicely explained 👍
As Always Indian, Thank you!
Thanks & very helpful
Thank you so much. This was very helpful!
I will be greatfull to u.I am a subscriber of your channel
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.
Xlent information... Sir... That reduced my time.... To make a sheet.... Thank you... 👌👌👌
That's great!
thank you i cried for 30 minutes trying to figure this out
Are able to do the same thing in Microsoft Word?
Thank you so much!!!! I have been working on this for an hour!!
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 ?
Nice teaching way.. I like it
very helpful i loved it....
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'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?
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.
Thank you so much sir
This is cool and thank you
The "Custom Format" option doesn't show up for me in Microsoft Excel. Is this a new feature? Thank you
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
very helpful. thanks!
Thank you very much
Well done, thank you sir.
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?
thank you 💗
You're welcome 😊
How about the color of the text on dropdown list?
Thank you sir..🙏
Amazing 🙏
if i enter "C" in grade column then it comes automatically "Fail" in Pass/Fail Column. How ???? please answer
Good video
How do i do the entire row?
how to keep the color, but we would like to add text
Very helpful - thank you!
Great, thank you. help me out
Thankkk youu alot
Exactly what I needed to know, plus other useful information. Thank you!
Hello Ram Gopal Ji You Can Also Think About MS Word Tutorial Video
Thanks for the suggestion Mukund!
@@PresentationProcess Welcome Again I Would Like To Say I Like Powerpoint Most Rather Than Excel And Word
Where is I Button in your video?
Thank you so much, Sir
🙏🙏🙏
Thank you so much for your Video, it is really helpful.
Lol 2:54 Ram got A grade but he got failed 😂
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
Plzzzzzzz Sir
Doesn’t work
Me too
Faltu