MS Excel - Conditional Formatting Part 1

Рет қаралды 1,242,247

6 жыл бұрын

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 "KZfaq" 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

Пікірлер: 365

@TutorialsPoint_ Жыл бұрын

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

@shriidharkulkarni6648 4 жыл бұрын

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.

@RA-rh5lb 4 жыл бұрын

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

@pritisharma8986 2 жыл бұрын

@samyabbas6574 4 жыл бұрын

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

@krishnapechiwala8417 3 жыл бұрын

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

@undisclosed8307 3 жыл бұрын

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

@salonisuryawanshi2059 Жыл бұрын

Really nice sir ❤️😍

@bhushanpimple9582 5 жыл бұрын

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.

@arunmarrimakulapalli8602 2 жыл бұрын

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

@rameshpower4259 2 жыл бұрын

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

@mohmmadkamrulislam1948 2 жыл бұрын

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

@nidhiagarwal02 4 жыл бұрын

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

@MrPGS2011 3 ай бұрын

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

@devramharak7934 4 жыл бұрын

Thank you,well explained.

@savitachaurasiya5952 5 жыл бұрын

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

@jamaludin-vb3fy 4 жыл бұрын

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

@25hkk 7 ай бұрын

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

@kurmarao1334 4 жыл бұрын

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

@mahjoubali 2 жыл бұрын

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

@shreyashkale.3137 3 жыл бұрын

these guys where way ahead of time..

@shailendrakumar7989 6 жыл бұрын

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

@adnangill5316 2 жыл бұрын

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

@positivevibes6996 5 жыл бұрын

Sir your vedio is really useful to overcome with problem

@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 2 жыл бұрын

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

@HSFR23 4 жыл бұрын

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 4 жыл бұрын

Hats off to your Explanation style

@nidhigupta7544 4 жыл бұрын

You deserve 1 billion subscribers

@mohdshakir5153 3 жыл бұрын

And you deserved 0 subscribers hahahahah

@Aspirants-Education 9 ай бұрын

Now, it's more than 3 millions!

@MdRafiqulIslam-bq9tm 2 жыл бұрын

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.

@anjaneyulukodam9961 Жыл бұрын

Thanks for your kindly explanation. Good evening sir,

@SumitKumar-bt4of 3 жыл бұрын

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

@ansar.p.kpilappilly1250 5 жыл бұрын

its really usefull.thanks a lot..

@ayeshadilawar4638 5 жыл бұрын

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

@pamilalincoln8684 5 жыл бұрын

Your vedios are great. Very useful. Thanks

@mokshyadav824 3 жыл бұрын

Vedios?😑🤣

@IT-Master_official2024. Жыл бұрын

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

@rambdrchand6354 5 жыл бұрын

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

@ganeshsonawane6201 5 жыл бұрын

Very helpfull video u create man.

@subhramaity9181 3 жыл бұрын

Your English speaking is just awesome i love too watched it

@TeliStu 2 жыл бұрын

m.kzfaq.info/get/bejne/oc9-q9uDu5Pagok.html

@vishaluniverse66 Жыл бұрын

One of my favourite guruji.

@gmatharu123 5 жыл бұрын

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

@biswajitgosh9318 4 жыл бұрын

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

@roohvlog4711 16 күн бұрын

THANK YOU VERY MUCH SIR WELL EXPLAINED

@tiktoktiktok4056 4 жыл бұрын

Well said...thank you very much

@Deshapremi Жыл бұрын

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

@tumuramyeyowasi3844 9 ай бұрын

Thanks because iam mastering excel from your lessons

@matheusdivine6954 3 жыл бұрын

You are the best sir, thank you so much

@Hafizabubakar873 11 ай бұрын

Well done sir best ever youtube for learning excel

@pawansudhamani6713 Жыл бұрын

Thanks for good information and explanation.

@tauseefsayed2581 3 жыл бұрын

It was an awsome explantion u just made it so easy

@kalpanaambhore4525 3 жыл бұрын

Thank you so much sir god bless you.

@azeemarizoo6873 3 жыл бұрын

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

@manish.raj7 4 жыл бұрын

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

@tamannagarg742 Жыл бұрын

Your videos are Lifesaving

@n3vab 3 жыл бұрын

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

@TeliStu 2 жыл бұрын

m.kzfaq.info/get/bejne/oc9-q9uDu5Pagok.html

@somemomentwithrudra803 Жыл бұрын

its quite helpful. thank you sir.

@701samad 4 жыл бұрын

thanks .a lot u did good job.

@karthikeyant3909 4 жыл бұрын

Simply great work

@sachinkanere007 2 жыл бұрын

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.

@quokka773 4 жыл бұрын

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 4 жыл бұрын

In which class do you read?

@boymalinao963 4 жыл бұрын

Very nice explanation..thanks sir..

@al-furqanislamicchannel8060 3 жыл бұрын

wow sir thanks it,s really good job.

@sachingauniyal5148 3 жыл бұрын

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

@cristianverde1202 4 жыл бұрын

Wow, so professional! Thums up!

@rakibuddin44 2 жыл бұрын

You are absolutely good teacher

@MsShahnawaj 5 жыл бұрын

Great learning efforts

@omegagamer4540 3 жыл бұрын

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

@arindamdas7342 3 жыл бұрын

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

@rohanshinde9619 7 ай бұрын

Your Teaching is Amazing 👍

@maryadebimpe9424 Жыл бұрын

Thank you for sharing your knowledge

@astonishingspy1459 5 жыл бұрын

Thanks that really help

@anugupta8257 4 жыл бұрын

Lots of thanks Sir for your explanation on this topic

@aryanmishra1163 4 жыл бұрын

Exellent explanation hats offf

@groeisterk 4 жыл бұрын

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

@suvakana3108 2 жыл бұрын

Sir your work is the greatest

@sanjuktasahu4133 5 жыл бұрын

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

@alexcarry511 10 ай бұрын

Hi mam

@adityasom8749 2 жыл бұрын

Best explanation great work ✌️📸👍

@aqeelahmed9928 5 жыл бұрын

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

@venkysakkuri9720 4 жыл бұрын

Fantastic

@sourabhchavan5902 6 жыл бұрын

Thank you sir.....

@filipbulev6756 3 жыл бұрын

A perfect tutorial.

@fantasyworld1591 3 жыл бұрын

Your style of teaching amazing, faboules 🥰

@hamaduddin1248 9 ай бұрын

well done sir you explained very easily ❤❤❤

@HumanityMatters85 Жыл бұрын

plz help.... I am using this formula in conditional formatting in office 2019 version =SUM(B$3:INDEX(B$3:B3,ROWS(B$3:B3)-1))

@prititiwari6897 5 жыл бұрын

Thank you so much sir. U really explained very nicely and covered so many things in a less time without wasting time ..I appreciate your all the videos.👍keep doing

@samirshaik938 2 жыл бұрын

Bro you are Excellent teacher ✌️🙂

@shivanisonavane3296 Жыл бұрын

explanation so nicely thank u

@PriyaSharma-uy7jx 6 жыл бұрын

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

@anshhthakur_ 2 жыл бұрын

Ysss

@manish_patil_mane Жыл бұрын

Yes sir

@jambunathbc 3 жыл бұрын

Thnk u , iam learning daily

@la9753 5 жыл бұрын

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

@BhuvikshaSingh 4 жыл бұрын

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

@giseleteghen4247 3 жыл бұрын

You deserve an accolade ur explicit I love u

@tarunrishiraj2111 3 жыл бұрын

Very simple way.... thanks sir

@premstha9797 4 жыл бұрын

you are simply awesome sir

@roskelly4825 5 жыл бұрын

Thank you for sharing, this video is clear and easy to understand.

@abdulmuttalib620 3 жыл бұрын

Thank you so much 💕❤️

@nikadolidze9511 4 жыл бұрын

i have name and surname in one cell and i wont to format cells in wich surname contains certain letters, how i can solve this?

@roshanheeramun9856 4 жыл бұрын

Thank you for your straight forward explanations

@aishamatin5962 3 жыл бұрын

Best excel video so far

@preethamari52 3 жыл бұрын

Tq ..it's very useful to me

@AKHIL0051 5 жыл бұрын

Thank you man

@e-skillmedia569 4 жыл бұрын

Well Explain, Thanks

@rpsinghsethi 4 жыл бұрын

If I want to put the conditional formatting on 1 to 10 numbers in which the number 1 and 2 should become green or above 2 number becomes orange or above 5 numbers becomes red then how we will implement it