MS Excel - Conditional Formatting Part 1
Вставка
- Опубліковано 26 сер 2024
- MS Excel - Conditional Formatting Part 1
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Check out the latest MS Excel Online Training courses on bit.ly/38Jyu3p
Use coupon "UA-cam" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialsp...
For more updates on courses and tips follow us on:
Facebook: / tutorialspointindia
Twitter: / tutorialspoint
LinkedIn: / tutorialspoint
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Excellent. I have no words to express my appreciation. I was struggling with this concept and tried to learn from many books but was unable to comprehend. Your video clip clearly demonstrates how to use this method. Thanks a lot.
I have never seen any computer teacher speaking and explaining fluently like this sir!🔥You are great🎉
Really nice sir ❤️😍
You truly need big applaud for your simple teaching style in English. Thanks.. you are my favorite trainer for Excel in English.
Hi
Teaching is an art n u have mastered it. You are Great Teacher. Keep Teaching. The world need teachers like u. I think excel should also be included in school curriculum.
Public Service without expectations, Nice Video & Great job done by you
You deserve 1 billion subscribers
And you deserved 0 subscribers hahahahah
Now, it's more than 3 millions!
One of my favourite guruji.
Your my model, Tanzania will benefit from me through your style
Very well explained the excel rules and commands. Thank you so much
I haven't even finished watching the whole video, i already like your lecturing, you make Excel simple. Thank you.
Your Lecture Really Needed For Local Institute As Well Local Teacher For Better Bhart(India)
I found Excellent Teacher after soo much search.. The way you explain it's very clear and understandable.. Thank you🙏
these guys where way ahead of time..
You are a MASTER brother 😍 How awesome & simple your Teaching style 🙃 Even LKG kids also understand , the way you teach 🔥🔥
SiR I have one request that please also give some assignments related to the topics so that we can try it.
Ysss
Yes sir
How to automatically stop the entry the quantity when the sum of total material velue will be exceed a certain limit?
No time pass, clicking intro videos...just the pure on topic work... excellent you deserve likes
I love your excel tutorials much and watch regularly. you deserves a lots of thanks as a good trainer. I want the help of jobs from you. If you give me some jobs about excel, I shall be grateful to you.
I am Bangladeshi.
I am a school student so it's very use full
Man random Indian guys on youtube are so much better than teachers
Your English speaking is just awesome i love too watched it
m.ua-cam.com/video/kiNxxRV-vRU/v-deo.html
woow! Thank you for your clear teaching. I just crush on your smartness
Nicely explained and in a simple way, love your style and presentation skills Sir.
It's simply wow
Really clear, simple, direct to mind
thank you so much, i have been looking at so many videos and yours explained it so simply, i was finally able to do this function 😭
In which class do you read?
This is too easy to understanding Conditional Formatting, very useful video... Good Job.
agar ek column me category likhi ho (SC/ST/OBC/GEN) and doosre column me
marks, tab marks par conditional formatting category wale column ke
basis par laga sakte hai??
Example: For GEN & OBC marks less than 40 ko red karna hai and for SC/ST marks less than 35 ko red karna hai
THANK YOU VERY MUCH SIR WELL EXPLAINED
Very useful session
Sir ji ap bhot acha pdate ho sab samj m aa jata h
Exellent explanation hats offf
Thanks because iam mastering excel from your lessons
Congrats for your video. I learn tableau from you. You give the best explanations with examples among all of them I watch until now.
Excellent sir
You are a amazing sir.
You educate to so many people who want required these kind of class.we salute 🙏🙏
Thanks for your kindly explanation.
Good evening sir,
Well done sir best ever youtube for learning excel
Good. Very good. Thanks.
Is there any video on How to get a certain text coloured if the value in a cell fulfils certain criteria?
Example: A set of cells will contain Profit or Loss. My requirement is If the value is Profit the text must get a Blue colour and If the text will be Loss the text must get Red colour. How can this be done ???
Nice teaching.
Best excel video so far
Hats off to your Explanation style
Your Teaching is Amazing 👍
Great efforts and explain
Your videos are Lifesaving
Thanks for good information and explanation.
U r teaching so perfectly Sir... Really ur videos are so useful
Hi mam
Too much clarity. A GOOD GRIP ON THE ENGLISH LANGUAGE
Best teaching 💓
Bro you are Excellent teacher ✌️🙂
Sir could you help me...date option is not working in my computer...yesterday this week or month😊 by the way your all vedios are helpfull...ur vedios will improve my English and excell also.... like 1 teer 2 nishane😅
explanation so nicely thank u
Thank you,well explained.
well done sir you explained very easily ❤❤❤
Sir your work is the greatest
More good way of teaching as compare to I imagined...
Awesome tutorial and very helpful
Fantastic
Sir Aap itna achha padate concept lekin hindi video chahiye tha
Tq ..it's very useful to me
can you explain the easiest way to apply conditional formatting in the cell where each cell is highlighted in red with reference to another cell reference like Cell A1: 50 and cell C1:40, I want to highlight cell C1 as red if Cell A1>Cell C1. I can do that for single-cell but if the sheet has more than 100 cells it's quite tedious to apply 1by1.
Very nice explanation..thanks sir..
Hahahahahaha.You are a very good and simple teacher.
So nice of you Sir ,
Realy a great Teacher....... 💞💞💞
I am unable to do conditional formating for my excel-
i want to get a color gradient table based on the occurence of the topic ie. i prepared a list of weak topic in each mock, want the sheet to get intensified in color with increasing frequency in subsequen mock. pls help..
The way you explain in detail is just amazing n intelligently. I love your videos. Awesome sir for teaching nicely n simply
Thank you Bro! it is very helpful and your ability to convey the subject is really awesome!
m.ua-cam.com/video/kiNxxRV-vRU/v-deo.html
You are absolutely good teacher
Love the method. Touching each and every small options. Highly appreciated. Thanks 🙏
Superb video. Explained in simple terms.
i like ur videos very much and it helped me to teach in my classes
Nice and clear explained
Thank you very much for these lectures.. They are really helpful.
thanks .a lot u did good job.
Will u please publish a vedio on "Custom formatting"
what a great videos u posted, thanks very much, could please videos on CIVIL ENGINEERING PROJECT PLANNER, PLANNED VERSES ACTUAL, as I am civil engineer, it would be great help, thanks once again
Thanks for making this type of valuable videos.. More Important thing is to get the good English fluent as well advanced excel...
Hi....
The way you xplain is ultimate..... Super....
Can you address my issue ?
There are some odd 15000 rows, I want to check / highlight duplicate / unique values between two diff columns and not rows......
How can I do that....?
Thanks sir👍👍
It was an awsome explantion u just made it so easy
Sir your vedio is really useful to overcome with problem
Very simple way.... thanks sir
Iam seen regularly your videos, such a very easy way to learn, your r great teachers.
If I have for example 3 columns that can have dates put into them, and I want to have a 4 column that shows 6 months from the last date added. How do I do that? Thank you.
Best explanation great work ✌️📸👍
Your vedios are great. Very useful. Thanks
Vedios?😑🤣
I love this class
**Excellent**
Lil bro really said expaaaanding
Thank you so much for great videos to learn advance excel quite easily. Stay blessed always!!
You are very good explainer. Te
You really helped in my it exam Thankyou
Nice explanation.
great thx, specially do it live with screen u work with!!!
Thank you for sharing your knowledge
Thnk u , iam learning daily
best sir
You are the best sir, thank you so much
Great teaching
Thanks for explaining excel in a simple way within a few minutes 🙏🙏☺☺😊
can you make a video on data validation multiple rows or multiple columns?
Worth it amazing video
Best teaching