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 "KZbin" 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 "KZbin12" 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 "KZbin" 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

[@krishnapechiwala8417]

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

[@samyabbas6574]

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

[@mohmmadkamrulislam1948]

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

[@devramharak7934]

Thank you,well explained.

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

[@savitachaurasiya5952]

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

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

[@nidhiagarwal02]

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

[@jamaludin-vb3fy]

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

[@25hkk]

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

[@kurmarao1334]

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

[@adnangill5316]

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

[@rameshpower4259]

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

[@ansar.p.kpilappilly1250]

its really usefull.thanks a lot..

[@shailendrakumar7989]

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

[@undisclosed8307]

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

[@salonisuryawanshi2059]

Really nice sir ❤️😍

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

[@shockey3084]

Hats off to your Explanation style

[@ganeshsonawane6201]

Very helpfull video u create man.

[@MsShahnawaj]

Great learning efforts

[@positivevibes6996]

Sir your vedio is really useful to overcome with problem

[@karthikeyant3909]

Simply great work

[@vishwanathgadgil3597]

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

[@astonishingspy1459]

Thanks that really help

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

[@mahjoubali]

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

[@cristianverde1202]

Wow, so professional! Thums up!

[@anjaneyulukodam9961]

Thanks for your kindly explanation. Good evening sir,

[@filipbulev6756]

A perfect tutorial.

[@sourabhchavan5902]

Thank you sir.....

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

[@tamannagarg742]

Your videos are Lifesaving

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

[@SumitKumar-bt4of]

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

[@somemomentwithrudra803]

its quite helpful. thank you sir.

[@vishaluniverse66]

One of my favourite guruji.

[@IT-Master_official2024.]

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

[@pamilalincoln8684]

Your vedios are great. Very useful. Thanks

[@mokshyadav824]

Vedios?😑🤣

[@biswajitgosh9318]

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

[@kalpanaambhore4525]

Thank you so much sir god bless you.

[@tumuramyeyowasi3844]

Thanks because iam mastering excel from your lessons

[@AKHIL0051]

Thank you man

[@tauseefsayed2581]

It was an awsome explantion u just made it so easy

[@roohvlog4711]

THANK YOU VERY MUCH SIR WELL EXPLAINED

[@pawansudhamani6713]

Thanks for good information and explanation.

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

[@matheusdivine6954]

You are the best sir, thank you so much

[@subhramaity9181]

Your English speaking is just awesome i love too watched it

[@TeliStu]

m.kzbin.info/www/bejne/oZqxqauIi5KpiLc

[@boymalinao963]

Very nice explanation..thanks sir..

[@rakibuddin44]

You are absolutely good teacher

[@ayeshadilawar4638]

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

[@Hafizabubakar873]

Well done sir best ever youtube for learning excel

[@abdulmuttalib620]

Thank you so much 💕❤️

[@tiktoktiktok4056]

Well said...thank you very much

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

[@701samad]

thanks .a lot u did good job.

[@suvakana3108]

Sir your work is the greatest

[@rohanshinde9619]

Your Teaching is Amazing 👍

[@preethamari52]

Tq ..it's very useful to me

[@premstha9797]

you are simply awesome sir

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

[@Deshapremi]

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

[@shivanisonavane3296]

explanation so nicely thank u

[@sachingauniyal5148]

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

[@maryadebimpe9424]

Thank you for sharing your knowledge

[@e-skillmedia569]

Well Explain, Thanks

[@mostofaakash6898]

Thanks a lot.

[@abhilashaasha9859]

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

[@suriyabalaji3352]

Very clear explanation

[@anugupta8257]

Lots of thanks Sir for your explanation on this topic

[@pthirumalai2581]

Will u please publish a vedio on "Custom formatting"

[@al-furqanislamicchannel8060]

wow sir thanks it,s really good job.

[@PankajPal-ww3yr]

Great efforts and explain

[@adityasom8749]

Best explanation great work ✌️📸👍

[@nidhigupta7544]

You deserve 1 billion subscribers

[@mohdshakir5153]

And you deserved 0 subscribers hahahahah

[@rahul_tsl]

Now, it's more than 3 millions!

[@jambunathbc]

Thnk u , iam learning daily

[@aishamatin5962]

Best excel video so far

[@ashwingamerz8873]

I love this class

[@asifshaikh863]

Thanks for helping

[@tarunrishiraj2111]

Very simple way.... thanks sir

[@raghavbairwa9663]

Thaaaaaannks sir so helpful

[@MonirulIslam-rq5vh]

Thanks a lot 🙏🙏

[@n3vab]

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

[@TeliStu]

m.kzbin.info/www/bejne/oZqxqauIi5KpiLc

[@groeisterk]

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

[@hamaduddin1248]

well done sir you explained very easily ❤❤❤

[@ambihasenthilkumar5050]

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

[@palipassport2825]

Tq bro I have understood

[@samirshaik938]

Bro you are Excellent teacher ✌️🙂

[@azeemarizoo6873]

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

[@NikitaQueen-writer]

Thx a lot 😇

[@giseleteghen4247]

You deserve an accolade ur explicit I love u

[@aryanmishra1163]

Exellent explanation hats offf

[@bollywoodentertainment3567]

Thank you sir...🙏

[@Shivam98677]

Thankyou Sir!!

[@pradipmali3650]

Worth it amazing video