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 "CZcams" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialspoint.com/market...
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 "CZcams12" 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.

[@TutorialsPoint_]

Check out latest MS Excel Online Training
courses on : bit.ly/38Jyu3p
Use coupon "CZcams" to get FLAT 10% OFF

[@Krishnaaaa08]

Op

[@smartstudywithaj6259]

Ok sit

[@tawandamutingwende5616]

Asking for assistance on something l am failing to do. I would like to design as follows:
1st column filtering yes/no; second column with due dates; and final column with colours i.e. IF 1st column is No and action plan has passed its due date then column becomes red,
IF 1st column is No and action plan has not reached its due date then column becomes yellow;
and IF 1st column is Yes a then column becomes green.

[@sanrock21]

I want data depending on cell status i have Active and Closed. So i have data in A,B and in C i have Active or Closed, So If i select Closed then data in A,B should add up and be displayed in column D, how can we do it?

[@IT-Master_official2024.]

I never get simplicity style of teaching as your brother,Bravo

[@mohmmadkamrulislam1948]

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

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

[@MrPGS2011]

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

[@samyabbas6574]

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

[@krishnapechiwala8417]

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

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

[@undisclosed8307]

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

[@salonisuryawanshi2059]

Really nice sir ❤️😍

[@devramharak7934]

Thank you,well explained.

[@savitachaurasiya5952]

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

[@25hkk]

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

[@arunmarrimakulapalli8602]

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

[@shreyashkale.3137]

these guys where way ahead of time..

[@rameshpower4259]

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

[@nidhiagarwal02]

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

[@adnangill5316]

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

[@jamaludin-vb3fy]

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

[@positivevibes6996]

Sir your vedio is really useful to overcome with problem

[@ansar.p.kpilappilly1250]

its really usefull.thanks a lot..

[@kurmarao1334]

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

[@shockey3084]

Hats off to your Explanation style

[@shailendrakumar7989]

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

[@mahjoubali]

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

[@MsShahnawaj]

Great learning efforts

[@IT-Master_official2024.]

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

[@anjaneyulukodam9961]

Thanks for your kindly explanation.
Good evening sir,

[@tamannagarg742]

Your videos are Lifesaving

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

[@karthikeyant3909]

Simply great work

[@tumuramyeyowasi3844]

Thanks because iam mastering excel from your lessons

[@astonishingspy1459]

Thanks that really help

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

[@vishwanathgadgil3597]

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

[@vishaluniverse66]

One of my favourite guruji.

[@ganeshsonawane6201]

Very helpfull video u create man.

[@filipbulev6756]

A perfect tutorial.

[@pamilalincoln8684]

Your vedios are great. Very useful. Thanks

[@mokshyadav824]

Vedios?😑🤣

[@roohvlog4711]

THANK YOU VERY MUCH SIR WELL EXPLAINED

[@subhramaity9181]

Your English speaking is just awesome i love too watched it

[@TeliStu]

m.czcams.com/video/kiNxxRV-vRU/video.html

[@Hafizabubakar873]

Well done sir best ever youtube for learning excel

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

[@rakibuddin44]

You are absolutely good teacher

[@pawansudhamani6713]

Thanks for good information and explanation.

[@tauseefsayed2581]

It was an awsome explantion u just made it so easy

[@somemomentwithrudra803]

its quite helpful. thank you sir.

[@rohanshinde9619]

Your Teaching is Amazing 👍

[@boymalinao963]

Very nice explanation..thanks sir..

[@suvakana3108]

Sir your work is the greatest

[@matheusdivine6954]

You are the best sir, thank you so much

[@aryanmishra1163]

Exellent explanation hats offf

[@kalpanaambhore4525]

Thank you so much sir god bless you.

[@arindamdas7342]

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

[@sourabhchavan5902]

Thank you sir.....

[@SumitKumar-bt4of]

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

[@Deshapremi]

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

[@aishamatin5962]

Best excel video so far

[@maryadebimpe9424]

Thank you for sharing your knowledge

[@premstha9797]

you are simply awesome sir

[@701samad]

thanks .a lot u did good job.

[@hamaduddin1248]

well done sir you explained very easily ❤❤❤

[@tarunrishiraj2111]

Very simple way.... thanks sir

[@AKHIL0051]

Thank you man

[@jambunathbc]

Thnk u , iam learning daily

[@samirshaik938]

Bro you are Excellent teacher ✌️🙂

[@adityasom8749]

Best explanation great work ✌️📸👍

[@e-skillmedia569]

Well Explain, Thanks

[@nidhigupta7544]

You deserve 1 billion subscribers

[@mohdshakir5153]

And you deserved 0 subscribers hahahahah

[@rahul_tsl]

Now, it's more than 3 millions!

[@anugupta8257]

Lots of thanks Sir for your explanation on this topic

[@abhilashaasha9859]

It's awesome ....sir ...

[@cristianverde1202]

Wow, so professional! Thums up!

[@ayeshadilawar4638]

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

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

[@pthirumalai2581]

Will u please publish a vedio on "Custom formatting"

[@abdulmuttalib620]

Thank you so much 💕❤️

[@biswajitgosh9318]

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

[@tiktoktiktok4056]

Well said...thank you very much

[@sahadevreddyv5017]

Excellent sir

[@user-vl9fl4oj2g]

Very useful session

[@sachingauniyal5148]

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

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

[@arushi6294]

In which class do you read?

[@n3vab]

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

[@TeliStu]

m.czcams.com/video/kiNxxRV-vRU/video.html

[@raghavbairwa9663]

Thaaaaaannks sir so helpful

[@azeemarizoo6873]

Sir, excellent job. Nice explanation. I learnt a lot from u.may Allah bless you

[@al-furqanislamicchannel8060]

wow sir thanks
it,s really good job.

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

[@groeisterk]

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

[@roshanheeramun9856]

Thank you for your straight forward explanations

[@giseleteghen4247]

You deserve an accolade ur explicit I love u

[@PankajPal-ww3yr]

Great efforts and explain

[@ambihasenthilkumar5050]

Thank you sir.. U r class is very helpful..

[@omegagamer4540]

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

[@AnandGautam9901]

Nice effort pawan sir

[@fantasyworld1591]

Your style of teaching amazing, faboules 🥰

[@suriyabalaji3352]

Very clear explanation

[@pratikshyamohapatra6598]

Good Explaining Sir 🙏🏻🙏🏻

[@BhuvikshaSingh]

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

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

[@sanjuktasahu4133]

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

[@alexcarry511]

Hi mam