Customized Conditional Formatting :Part 1 | Smart ways to use advanced custom conditional formatting
HTML-код
- Опубликовано: 20 авг 2024
- Customized Conditional Formatting
Smart ways to use advanced custom conditional formatting.
Basic Excel Playlist Link - • Basic Excel-The Learni...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#msexcel #excelconditionalformatting #exceltutorial #innozant
Sir G Behtreen(Excellent).🥰
sir aapki vedios dekh kar mujhe bahyut help mila hai thank you very much
sir
Thanks dear bhai. Very helpful your free video
Thanks dear❤️❤️😊
Thank you so much.
Outstanding explanation sir. I already started to see your video from basic level. It helped me so much. I see your video and then practice. I live in West Bengal. I want to get a excel oriented job. But I have no computer certificate. So, thats why I see your excel video everyday and practice. I am 12th Science pass student no graduation. Now I am doing a computer course.
Thanks dear .Happy learning.Regular practice kriye.lag jayegi job❤🙏
u can learn from online cerfication also from source i can you links
A huge salute to you sir. You are a genius, hatts off to all your efforts.
Thanks Raj..Love you dear..God bless you..Happy learning
excellent!
Great sir Ji mai new hu aur apne sabhi friends ko share kar diya aapne bahut achhe se padhaya hai dhanyavaad
Thanks Dear..In sequence step by steo seekhiye..Basic Excel Playlist onwards
100% samaj me aya...
Great Sir, I have been seeing your lectures but today I surprised when I started to see your playlist and found this is completely Golden mine of Excel.
Why I didn't get it early but I will watch whole playlist.
very well expert hai ap masha Allah
Thanks
i am following your video's these are meannig full and helps me to understand excel fundamentals with new tricks THANKS A LOT
Sir G aap bahut ache se explain krte ho
Thanks Suraj for your valuable feedback,Will keep trying to post more videos.
Amazing topic sir
Guys please share the videos as much as you can. Spread the knowledge .
Thanks Shrikant ,Happy Learning.
Must watch Filter hacks and Interview Cracker series video.
Nice Explanation I always prefer to learn Advance excel from your Channel. Very nice explanation
Thanks
This video cleared my doubt formula doesn't impact highlighting cell..Great teaching 👍
Thanks Palak..Happy learning..God bless you dear
Again i am learning
Are wah...revise each and every topic dear..
AI TOOLS pr bhi ek playlist bna diziye sir..ki excel me kha or kaise use ho skti h..or wo bhi paid or unpaid dono tools
Thank you so much sir 👏 for your good explanation practically
Thanks dear
thnx you sir by devender
Great sir ji I am new student of your channel and sir aapke samjhane ka tarika bahut he shaandar h sir maja aa gya sir thank you so much sir main bhi MIS ki job k liye preparation kr rha hu sir ji🙏
Thanks Mr. Bisht..Aap Basic excel Playlist se step by step video dekhen..Aur practice file diya gya hai wahan se practice Karen.Koi issue aata hai to help milegi.kaise course learn karna gai uske liye ye video dekhen.
ruclips.net/video/2935505X3yU/видео.html
Thank you sir ji
Thankyou sir ji ❤
Amazing video sir
Thanks Sameer Ji
Understand sir ❤
Greatly Helpful. Thanks Sir.
❤️😊Thanks dear
thank you sir...
Thanks ❤️
Sir , Today , i understand Which dollar will be remove before I didn't understand after receiving training in Excel . Thanks Sir
thanks raghav ji
Sir awesome video again thank you so much
Thanks 👍❤️
Good Evening Sir
Thanks sir
good afternoon sir..i am following your all valueable vdos..bt i want to learn how to use AI TOOLS in excel...plz aap btaye..
THANK U SO MUCH FOR VIDEO SIR.. U MADE EVERYBODY UNDERSTAND VERY WELL. I HOPE U LL DO CONTINUOUS. I LL JOIN SOON .
Thanks dear for your feedback.
Finally got a chance today to see the next video in my learning as was busy with office stuff.
oh No issue..Cover the topic as much as you can
Love This!
Thanks Pawan
Thanks for given all mis's video
Happy to see you again start your learning journey
Thk ho gya sir but dusra sheet liya hu to kam kiya h
TQ...sir
hii sir me aapki viewrs hu aapki vedios dekhta hu sir mujhe mixed refrence nahi samjh aa raha tha isliye mene mixed refrence ki vedio chor kar aag bad gaya
Sir B ke age se $ sign hata dijiye
taki mujhey achey say smjh aa jaye
Sir ye jo 3rd example hai usme likha hai ki row aur column dono at same time highlight hone chahiye, par apne pehle row fir uske baad column kiye, but sir sath me kaise kare?
❤️❤️❤️❤️
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Sir ji aapke katha sunthe sunthe main answer be diya 🤣🤣🤣.. I wish I could attend your live class
Hahahaha.. Thanks..Jaroor dear.
live session me.connect ho sakte hain.For more information visit Innozant website
@@Innozant Sir ji jab Bhi live attend karenge tho pay kar ke aayenge.. let me complete the whole series first..
Sir ji A88 me 88 ke samne $ hataya wo concept samj me aaya lekhin A ke saath $ kyoo chaiye jsb ki column move tho nahi hoga
Sir, I want to Highlight all names in capital latter in using conditional formatting. ex- names(vijay , suresh, RAJESH, DINESH) only RAJESH and DINESH I want to highlight ,any solution for this
Sir aap essi trah part number deke add Kiya kriye video please
Harek playlist me videos in sequence hain dear
Nicely explained sir, if you have a video series on SQL Then pls send me the playlist link.
Thanks dear ..Sal video on RUclips is not available now..Live class training is available for the same
@@Innozant Sir what is the class Timing, how can i enroll into it . What is the fee structure??
@@AnkitSingh-mh7ee you may connect team Innozant for more information
@@AnkitSingh-mh7ee Kindly visit innozant website or you may directly contact innozant team for upcoming batches
Nice video sir, Agar hum koi perticular Name ka respective koi number search karna chahain( Jaha Column headings hoga NAME-NUMBER) toh kyese karain? Yaha ek Name ka respect main ek Number aur dusra Name ke under same number ho sakta hai .
1st option me mene E column me mobile k badle laptop rakha aur us hisaab se further steps kare, but woh mobile pe hi highlight dikharai sir aise kyu. Agar me apke settings k hisaab se karu toh sahi jarai, but mobile k badle laptop rakha toh fir b mobile hi highlight hota hai.
Sir mera formula shi se kaam ni kr rha h mobile pr to kaam kr rha h lekin jese hi camera ko type krta hu to wo camera ko highlight ni kr rha h
Hi Sir
Can I attempt 2 conditions in a single row!!
Hi sir plz practice file bhi share Kia kijiye
Sharma Ji . Already practice file hai.
Aap assignment master link se download kren complete playlist folder link hai wahan
🙏😊
सर मुझे डी10 सेल में सम का फार्मूला लगाना है जिसमे मुझे ए1 से लेकर एच 20 तक के सभी सेलस का सम करना है हो नही प् रहा है क्या आप मुझे बता सकते है कि में सम केसे करू
Sir m watching your videos but how can i get dummies data for practice
Dummy data kyu Pnakaj complete assigned series Rakha hai drive par .Kiai bhi video ke description me Jake download kar lijiye ..and start practice
👍
Sir, have you posted video on MACRO VBA in series as done in excel ,if not will you start doing so ??
Vba series not started now but will start it surely after finishing power series
Noted sir, thank you
sir mujhey custome formating nahi smjh aya to kya us pr aap deep mey ek vedio dey sktey h kya
plzzzz
Already karaynhua hai custom formatting dear.mdubara vieeo dekhiye aur jo excel sheet diya hai usse practice kar lijiye.aaygea samajh
Sir Drop Down List Create Kar Sakte Hain Jisse Baar Baar Name Nahi Likhna Pade
Haan Kyu Nahi..Data validation me Jake list create Kar lijiye
Sir, what if i should select top row of the data also??
top row like..why there is need to select top row
Sir .. highlight one column value me agr main product bich me se utha ta hu tou jo select area ka phela product hai wo highlight ho raha hai.. example k lie maine product me mobile ki jgh camera select kr lia
Jitna area highlight krna hai whi slwct kriye uska condition se koi lena dena nahin hai
@@Innozant ok sir thank you.!
Starting ke examples ki value sahi nhi highlight kr rha hai exact same aapke jaise krne pr bhi.....
@Innozant I want to learn Advance Excel if you provide any online or offline classes. Please suggest how I join.
Yes we are running online/offline classes for Data Analytics and Data Science.
You may connect us on call/whatsapp
For more info kindly visit innozant website
I want to join the course of power BI
You may connect us for more details about course(For contact kindly visit our website)
B
Hello sir
Sir agar 2 alg alg coulmn h jaise e or h to aisa krna h agr e=h h to green hojaye or agr equal nhi h value to red hojaye plzz explain me
Haan to dono ko comapare Kar lijiye ..Ek baar khud se laga ke dekhiye..aap jaisa chahte hain.koi issue aata hai ya ap jaisa chah re ho wo result nhi aata hai to btana mujhse
@@Innozant okk sir
Sir ye ho nhi pa rha kafi try krliya or sir apka whtsp no mil skta h kya
@@Automation531 Kyu kya isue aa raha hai,Video dhyan se dekhiye maine kaise kiya hai apply aur example hain already usse practise kijiye.Website par jo no. hai wo whatsapp hi hai ,u may message.
Hi Good Evening!! sir I am facing a problem in the second step, jab main mobile ko select krke highlight karri hu and saare steps follow krri hu toh mera mobile wala cell nahi ho raha coloured. but top product mein jab main camera pe change karri hu toh colours are visible. please reply
Aisa to nahi ki freeze hi chor de re hain aap data ko😊ek baar dekhiye jaise maine kiya hai waie steo fillow jijiye..tab bhi issue aata hai to batana..aapko zoon par connect krke guide kar denge
@@Innozant sir Maine same step Kiya freeze hatake but bas mobile pe hi Nahi aara baaki agar Kuch bhi agar type Krri Hu top product mein Jaise perfume, camera it's working but laptop wale mei Nahi Ara.
Galat kar re hain aap kuch..for sure
Nhi ho paaye to aap apne query ikatha kar lo.. zoom par connect krke guide kar denge aapko.saare doubt
@@Innozant okay sir thankyou so muchhh
Apka formula to kam ni kr rha h sir mere me sb ulta pulta ho ja rha h
Macro enabled file hoga use ..use enable krke use karen
free row
99
??
Sir apse what's app ke jariye kaise jud sakta hu🙏
Aap mujhse telegram I'd - @innozantofficial par connect kar skte h
sir apna email address batye and whatsp number code k sath share kijye main apkistan say hoon
innozantcampus@gmail.com
contact detail website se le lijiye ya channel ke about me bhi hai
@@Innozant Forbidden
You do not have permission to access this document.
Web Server at innozant.com ye likha ata hai aaap ki webiste pa
its working fine
@@Innozant sir where can I download practice data that you have used in the vidros
@@ShwetaBfit Download link are given in video description
Banda video banate waqt zoom kar leta hai kamas kam
Malik Sahab...Ye Start ke video hain ..Jab Channel create kiya tha...
Us waqt gyan nhi tha sir na hi Video edit krne ka kuch pata tha bus class ki screen recording upload kar diya tha.Maafi 😀❤️🙏
Recent video me ye prob sayad nhi ho ra ha hoga..start ke kuch video me thora kasht kaat lijiye lekin content samh me aayega aur life m valuable bhi add hoga apke .❤️❤️🙏🙏
@@Innozant 👍