Formula based Conditional formatting | MIS Reporting Tricks
HTML-код
- Опубликовано: 6 сен 2024
- Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
MIS Reporting Tricks
Download Practice files Click here bit.ly/2Lpjvyf
In this tutorial, we will learn about formula based conditional formatting in excel in detail.
conditional formatting in excel 2016
conditional formatting in excel 2013
excel conditional formatting based on another cell
conditional formatting definition
conditional formatting if statement
conditional formatting highlight row
excel conditional formatting if statement
Get 100% OFF on Excel Interview Essentials course Use Coupon Code - ESSJUL20
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
Formula-based Conditional formatting | MIS Reporting Tricks
#conditionalformatting #misreport #formulaconditionalformatting
To watch more videos visit: www.excelsuper...
To Buy an Excel Course Pen drive visit: www.excelsuper...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20*
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
You are so good briefly explain logical, thanks a lot.
Thanks with respect from Pakistan sir.
Sir you explain so well, anyone can understand. I have no words to Thank you!
Hard things looks easy when you explain. Big thanks to you sir
Sir aapki yah video bahut acchi thi 🙏🏻🙏🏻
You are too good. Excellent brother
Quality of a real teacher.
Bahut achha laga hai video
Thank you Sir Love and Respect From Pakistan
Thanks for sharing and explain with example and simple language
Bahut Badhiya
Bahot badiya
Great sir.
Thanks a lot for helping out in such an easy way. I'm having difficulty in creating excel spreadsheet my professor gave me can you help me out in that? I'd really appreciate that!
Wao amazing. I m ur fan. U r awesome. Please keep it up 👍👍👍. Adil Lahore Pakistan
Keep learning Adil Khan
Very Good.
Very much informative & useful, Thanks dear
your explaining is perfect,
Excellent 👌
Love and respect from Pakistan
Great sir 👌👌
It's amazing.
Rishav You are doing well.
Ek no.bhai
Good sir..
Superb
Informative video...and as always your sense of humour is great ...u really speak well...
Nice one
Excellent teaching
Great
Sir kindly share how to colour cell which were use to determine value..
Good Morning sir. This is the very good and knowledgeable video Thanks for this. But, i need to know if i choose a criteria, then as per my selection my data is automatically filtered and only those data will appear below the selection.
Please suggest and share me such video.
Super sir aur video banao issi par
U r great👍👍👏👏👏
Excellent
Great one as always!
Yr way f explaination is d outcome f creativity within u..
My last comment not got acknowledged, meaning requested for a video. By clicking in the left bottom corner in Excell how we can jump any sheet even we can add numbers f sheets into that tab .
Thanks
Nice thanks.
Joss formula
Dear Mr.Rishav, thanks for the nice tricks. But can you able to make video for DGET function. Who it different from index match formula.
Why I am asking you is because your way of teaching is very very easy. You keep the matter very simple. I had plenty video on index match, but believe me , my idea got cleared by watching ur video on Index match..
Last but not least, my assumption is you are from WB. Correct me ,if I wrong..😉
Nice video
#MISFamily
Very nice sir g
Nice
Thanks
Super star trick :)
Can you please make a video with regards to change in font color as well based on values Actual compared to budget? If answer is positive then font color should be green else red.
How to use less than or greater than simultaneously in this
Please add filter too in this method, so all coloured cells will on near down the heading 🇳🇵
Super!!
Hello Sir, How to calculate Emi on weekly basis... Please tell me the formula to calculate in Excel by using PMT formula.
Jabardast sirji
Saurabh sir please tell how I enter series in fill option (egg. 201to 1000 how I do waiting for Ur reply
Nice 👌
Respected sir please upload video on create school timetable
Hi, is there any video regarding linear regression in excel ...
bhai apki avaaj or presentation ka way itna filmy h k video dekhne k bad koi fir bhulega hi nahi
Sir searchable drop down list ke bareme bataiye
Excel add on par video banao.
SPC FOR EXCEL on priority
Sir isme sum ho sakta hai kya
sir, download link for practice file is not working
cell value change(ya phir update) hone par cell ka colour kaise change hoga?
Sir please koi aisi data validation batao jise lagane pr hum date or time dono enter kar paye agar agar date or time me se koi bhi ek mis hota he to data validation entry na karne de....
Sir two excel file Ko compare kaise kare??? Iske bare me bataye!!!
#nicr
Sir,
Can I hide uncolored data
Mujhe rows ke digit count Karne he and 0 bala cell count nahi karna please help my dear sir
sir
ager kisi me bhuat sare logo ka first name or last name hai....ager mujhe bole k jis jis ka last name "sharma" hai uaki pura row ko highlight kare.....
plesar sir kaise kare bathaye...
Sir, if any requirement in MIS thn pls inform me.
Sir me 80's me paida nhi hua. Par byomkesh bakshi k saare episodes kai baar dekhe he😀😀😀
What is Excel version you are using?
Excel 2016
Thank you.
Not so good bro , If i have more data and i will use this method. I wont find the coloured row and inorder to find the coloured row, i have to scroll much more down which waste time.
Question from nepal 🇳🇵🇳🇵
Sir mera 1 question h me chahta hu ki kisi bill ki amt 50000 hote h wo color ho jaaye
Rakesh Sahota new rule me jake type karo =if(amount>50000, true, false)
Go to conditional formatting ..
Select is equal to
....
Fill 50000
Select formating...
Done
If(cell reference=>,true,fase)
Unhe keval 50000 par formatting chahiye ....
Greater than par nahi....
Aur if ka logic lagane yaha koi jarurat nahi hai...Bhai...
Manage rule Cell reference C2 or any =50000