MS Excel - Conditional Formatting Part 1

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

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@shriidharkulkarni6648]

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.

[@undisclosed8307]

I have never seen any computer teacher speaking and explaining fluently like this sir!🔥You are great🎉

[@salonisuryawanshi2059]

Really nice sir ❤️😍

[@RA-rh5lb]

You truly need big applaud for your simple teaching style in English. Thanks.. you are my favorite trainer for Excel in English.

[@pritisharma8986]

Hi

[@bhushanpimple9582]

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.

[@MrPGS2011]

Public Service without expectations, Nice Video & Great job done by you

[@nidhigupta7544]

You deserve 1 billion subscribers

[@mohdshakir5153]

And you deserved 0 subscribers hahahahah

[@Aspirants-Education]

Now, it's more than 3 millions!

[@vishaluniverse66]

One of my favourite guruji.

[@IT-Master_official2024.]

Your my model, Tanzania will benefit from me through your style

[@nidhiagarwal02]

Very well explained the excel rules and commands. Thank you so much

[@mahjoubali]

I haven't even finished watching the whole video, i already like your lecturing, you make Excel simple. Thank you.

[@shailendrakumar7989]

Your Lecture Really Needed For Local Institute As Well Local Teacher For Better Bhart(India)

[@rameshpower4259]

I found Excellent Teacher after soo much search.. The way you explain it's very clear and understandable.. Thank you🙏

[@shreyashkale.3137]

these guys where way ahead of time..

[@arunmarrimakulapalli8602]

You are a MASTER brother 😍 How awesome & simple your Teaching style 🙃 Even LKG kids also understand , the way you teach 🔥🔥

[@PriyaSharma-uy7jx]

SiR I have one request that please also give some assignments related to the topics so that we can try it.

[@anshhthakur_]

Ysss

[@manish_patil_mane]

Yes sir

[@biswajitgosh9318]

How to automatically stop the entry the quantity when the sum of total material velue will be exceed a certain limit?

[@vishwanathgadgil3597]

No time pass, clicking intro videos...just the pure on topic work... excellent you deserve likes

[@MdRafiqulIslam-bq9tm]

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.

[@arindamdas7342]

I am a school student so it's very use full

[@omegagamer4540]

Man random Indian guys on youtube are so much better than teachers

[@subhramaity9181]

Your English speaking is just awesome i love too watched it

[@TeliStu]

m.ua-cam.com/video/kiNxxRV-vRU/v-deo.html

[@mohmmadkamrulislam1948]

woow! Thank you for your clear teaching. I just crush on your smartness

[@25hkk]

Nicely explained and in a simple way, love your style and presentation skills Sir.

[@Deshapremi]

It's simply wow
Really clear, simple, direct to mind

[@quokka773]

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 😭

[@Weirdogirl_20]

In which class do you read?

[@ayeshadilawar4638]

This is too easy to understanding Conditional Formatting, very useful video... Good Job.

[@gmatharu123]

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

[@roohvlog4711]

THANK YOU VERY MUCH SIR WELL EXPLAINED

[@user-vl9fl4oj2g]

Very useful session

[@sachingauniyal5148]

Sir ji ap bhot acha pdate ho sab samj m aa jata h

[@aryanmishra1163]

Exellent explanation hats offf

[@tumuramyeyowasi3844]

Thanks because iam mastering excel from your lessons

[@kostasvalanidis7560]

Congrats for your video. I learn tableau from you. You give the best explanations with examples among all of them I watch until now.

[@sahadevreddyv5017]

Excellent sir

[@samyabbas6574]

You are a amazing sir.
You educate to so many people who want required these kind of class.we salute 🙏🙏

[@anjaneyulukodam9961]

Thanks for your kindly explanation.
Good evening sir,

[@Hafizabubakar873]

Well done sir best ever youtube for learning excel

[@CVPcreations]

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 ???

[@arunrharisree]

Nice teaching.

[@aishamatin5962]

Best excel video so far

[@shockey3084]

Hats off to your Explanation style

[@rohanshinde9619]

Your Teaching is Amazing 👍

[@PankajPal-ww3yr]

Great efforts and explain

[@tamannagarg742]

Your videos are Lifesaving

[@pawansudhamani6713]

Thanks for good information and explanation.

[@sanjuktasahu4133]

U r teaching so perfectly Sir... Really ur videos are so useful

[@Ashishkumar-y7k6l]

Hi mam

[@javedahmed8343]

Too much clarity. A GOOD GRIP ON THE ENGLISH LANGUAGE

[@prajaktathorve5064]

Best teaching 💓

[@samirshaik938]

Bro you are Excellent teacher ✌️🙂

[@zoyafarooqi5097]

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😅

[@shivanisonavane3296]

explanation so nicely thank u

[@devramharak7934]

Thank you,well explained.

[@hamaduddin1248]

well done sir you explained very easily ❤❤❤

[@suvakana3108]

Sir your work is the greatest

[@aqeelahmed9928]

More good way of teaching as compare to I imagined...
Awesome tutorial and very helpful

[@venkysakkuri9720]

Fantastic

[@amitsahare6777]

Sir Aap itna achha padate concept lekin hindi video chahiye tha

[@preethamari52]

Tq ..it's very useful to me

[@sachinkanere007]

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.

[@boymalinao963]

Very nice explanation..thanks sir..

[@obenaugustine8467]

Hahahahahaha.You are a very good and simple teacher.

[@adnangill5316]

So nice of you Sir ,
Realy a great Teacher....... 💞💞💞

[@manish.raj7]

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

[@krishnapechiwala8417]

The way you explain in detail is just amazing n intelligently. I love your videos. Awesome sir for teaching nicely n simply

[@n3vab]

Thank you Bro! it is very helpful and your ability to convey the subject is really awesome!

[@TeliStu]

m.ua-cam.com/video/kiNxxRV-vRU/v-deo.html

[@rakibuddin44]

You are absolutely good teacher

[@SumitKumar-bt4of]

Love the method. Touching each and every small options. Highly appreciated. Thanks 🙏

[@tamilkeerthi]

Superb video. Explained in simple terms.

[@savitachaurasiya5952]

i like ur videos very much and it helped me to teach in my classes

[@radhikaanitha9047]

Nice and clear explained

[@la9753]

Thank you very much for these lectures.. They are really helpful.

[@701samad]

thanks .a lot u did good job.

[@pthirumalai2581]

Will u please publish a vedio on "Custom formatting"

[@rambdrchand6354]

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

[@sanjaynoudiyal9467]

Thanks for making this type of valuable videos.. More Important thing is to get the good English fluent as well advanced excel...

[@dhanishmehta]

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....?

[@chetanbanger9198]

Thanks sir👍👍

[@tauseefsayed2581]

It was an awsome explantion u just made it so easy

[@positivevibes6996]

Sir your vedio is really useful to overcome with problem

[@tarunrishiraj2111]

Very simple way.... thanks sir

[@kurmarao1334]

Iam seen regularly your videos, such a very easy way to learn, your r great teachers.

[@HSFR23]

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.

[@adityasom8749]

Best explanation great work ✌️📸👍

[@pamilalincoln8684]

Your vedios are great. Very useful. Thanks

[@mokshyadav824]

Vedios?😑🤣

[@ashwingamerz8873]

I love this class

[@anisurrahman8551]

**Excellent**

[@legendarygamer2603]

Lil bro really said expaaaanding

[@jamaludin-vb3fy]

Thank you so much for great videos to learn advance excel quite easily. Stay blessed always!!

[@BhuvikshaSingh]

You are very good explainer. Te
You really helped in my it exam Thankyou

[@musiccollection4302]

Nice explanation.

[@groeisterk]

great thx, specially do it live with screen u work with!!!

[@maryadebimpe9424]

Thank you for sharing your knowledge

[@jambunathbc]

Thnk u , iam learning daily

[@muhammadyaqoob1869]

best sir

[@matheusdivine6954]

You are the best sir, thank you so much

[@prosenjitbanerjee7490]

Great teaching

[@sid8768]

Thanks for explaining excel in a simple way within a few minutes 🙏🙏☺☺😊

[@somnathparamanick1992]

can you make a video on data validation multiple rows or multiple columns?

[@pradipmali3650]

Worth it amazing video

[@abaawn_caqlisame]

Best teaching