Conditional Formatting Advanced-1 | Excel Conditional Formatting with Formulas and Form Controls.

Conditional Formatting Advanced | Excel Conditional Formatting with Formulas and Form Controls.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========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...
#conditionalformatting#excelconditionalformatting#innozant #exceltutorial#formacontrols

[@shreeram90861]

Sir ji ab vba series bi start kr dijiye 🙏🙏

[@Innozant]

Thanks dear .Haan start krenge

[@sandeepaswal8944]

Thank you so much sir ji❤Provide this video. Always I revise your all playlist videos. You are great teacher ❤

[@Innozant]

Thanks Ssndepe ji

[@himanshugurwani2608]

Type conditional formatting found your video truly learn new things from this video .
Thanks for this video.

[@parthahati2284]

Absolutely sublime sir.
you are explaining every single step so well. Lucky to have you as our teacher sir

[@Innozant]

Thanks Partha..God bless you dear

[@iamsainipawan]

Sir tally course BHI provide kijiye in future very helpful to me because as I always said your teaching methods is exceptional please sir🙏🙏🙏🙏

[@Innozant]

👍abhi to nahin

[@birendrabahuguna7339]

Brother am following many excel channels. But u r genius and extraordinary. Luv u bro

[@Innozant]

Thank you so much 😀

[@megha_says7337]

i got so much ideas from your videos & i am using it for my business. Thanks.....

[@Innozant]

Thanks dear...That's great 👍♥️

[@allinonelearning539]

Really sir i recently started watching your videos and that's blown my mind...😊😊
I am also a computer trainee and your channel is really helpful for me .. 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼.. Thank you so much sir ....
You are doing such a great work... ❤️❤️❤️❤️🔥🔥🔥🔥

[@Innozant]

Thanks Gupta Ji..God Bless You dear.Happy learning

[@allinonelearning539]

@@Innozant ❤️☺️😇❤️

[@avinashghanghav2239]

Just wow..I have learned a lot from your videos sir..thanku

[@ComputerSiksha100]

One Of The Best Teacher Sir ❤❤❤

[@harishsingh2958]

So amz.. Sir.. Ur teaching style so so gud.. Shayd hi koi hoga jo samjh n payeaga.....👏👏👏👏

[@Innozant]

Thanks Harish Ji

[@pramodbhavsar4488]

Very nice example of conditional formating very useful thank you Sir

[@Innozant]

Thanks Paramod Ji..❤️

[@dqfashionfactory6470]

There are plenty of videos on TH-cam but we can able learn only in this channel 😊

[@Innozant]

Thanks dear..God bless You..Happy Learning ❤️

[@bhardwaj7272]

आप विस्‍तार से बताते हो जैस आप # @ ! ~ बारे में बताये हो मतलब एक भी प्‍वाईट को छोड़ते नहीं जो बताना चाहिए उसे अवश्‍य बताते है ये आप में एक विशेष गुण् है जैस ये सिम्‍बल आया टीचिंग करते समय तो इसके बारे में भी बता देते हो क्‍यों किसलिए और कहां प्रयोग होता है यह बात मुझे अच्‍छी लगी, great SIR

[@Innozant]

Thanks Laxman.. Happy Learning ❤️

[@SVS609]

Really Super..Learnt nice thing
Thank you Sir

[@muhammadnaeem4237]

Sir your method of is very good.

[@Innozant]

Thanks dear❤️👍

[@ta20111996]

Nice and learning full. Thanks

[@sakibtalukder-6890]

Thank You Sir.

[@kishorpanara4191]

Sir aap recaps karo bhir bhi mere liye to fresh hi hota hai Thank you my dear Sir

[@Innozant]

Thanks Dear Kishor ji..Happy learning dear

[@jayantabhattacharyya628]

Dear Sir
Excellent conditional formatting tutorial. Though you had uploaded this kind of conditional formatting videos earlier, it's a recap for me. Again I like the video.
Thanks & Regards
Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta...Happy learning

[@createyour6681]

Very great sir

[@Raidas82020]

It's very useful in dashboard. Thanks

[@Innozant]

Thanks Suraj

[@anitasinha7278]

Superb sir as usual

[@Innozant]

Thanks Anita ❤️❤️👍

[@satishojha6240]

Thanku for the recap sir 🙏🙏🙏🙏. good night

[@Innozant]

Thanks Satish Ji..Good Night ❤️

[@mdibrahimsheikh1680]

Thanks for your tutorial....👌

[@Innozant]

Thanks Ibrahim sahab

[@AliAli-xx1ry]

Well explained sir
Lots of respect 😇
& Love from Pakistan❤
Keep growing sir🤞

[@Innozant]

Thanks Ali

[@rhashmi1]

Very nice. Beautiful

[@Innozant]

Thanks Rashid sahab

[@SachinSharma-lh8cq]

Sir agar cell me likhe hue kisi particular word ko highlight krna ho

[@rafiqueahmed2571]

Sir, i have regularly watched your video and learned a lot of commands.
Sir my querry is that:-
I have reconciled in the master file with sale slip with vlookup command if it record is the same the only receipt no. copy offset formula with macro command in another sheet here is i have easily work done. Difficulty arriving here is that when i conditional formatting in master file with slip copy in another sheet. Kindly tell me how to do this. Thanks

[@nitishsharma4677]

Great sir

[@vishwaschavan7182]

Thanks a lots for not only teaching new concept but also recapping the earlier learnings 👌

[@Innozant]

Thanks Vishwas Ji .Happy learning

[@hsgusain2054]

Thanks sir Ji

[@Innozant]

Thanks dear

[@sameenarafiq1339]

Awesome ... Dear Sir

[@Innozant]

Thanks Sameena ❤️ for being part of Innozant family

[@surinderkumar-hq2rm]

Awesome sir thanks

[@Innozant]

Thanks Surinder ji..Good Night

[@bhoopendraraghav9781]

Very Nice

[@sathyanarayana4914]

Beautiful vedeio

[@Ann_2208]

Great sir 👍

[@muhammadsaqlain5162]

very well

[@manojkumarsingh3385]

Super sir ji
🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks Manoj

[@PriyodipBhattacharjee]

Agar Koi Cell 35% haii to wo cell Highlight ho Jaye?use to Confidential formatting

[@sawaimalhi8439]

Firt comments sir aaap ka student

[@Innozant]

Thanks dear

[@arunkumarsahu4938]

Thank you sir

[@Innozant]

Thanks Arun Ji

[@pandharinathjoshi6565]

Superb sir

[@Innozant]

Thanks dear

[@rajeshtamang4408]

Excellent

[@Innozant]

Thanks Rajesh

[@dqfashionfactory6470]

custom formatting, pls help us to know on this chapter

[@RahulChauhan-ll9pu]

Superb 👍

[@Innozant]

Thanks Rahul ji

[@asiflashari532]

respects from ur student in pakistan 🇵🇰🙏

[@Innozant]

Thanks Asif sahab..❤️

[@tejpalsain1507]

Very nice.

[@Innozant]

Thanks Tejpal❤️

[@sawaimalhi8439]

Sir ek dafa mixed reference samja dain tu bahit badiya hoga

[@Innozant]

Already video hai dear

[@ashokdas2568]

Wow

[@PrashantSingh-mn4pg]

Sir filter me formula kaise copy karke paste kare

[@alpeshpanchal7994]

Nice video sir ji

[@Innozant]

Thanks Alpesh ji

[@manojkumarsingh3385]

Sir 3D Map chart Ka use Ka explain kijiye please
🙏🏻🙏🏻🙏🏻🙏🏻

[@Innozant]

Ok..chart and graph series me batete h

[@TheCSPlaybookShorts]

Excellent video. I want to learn and identify "keyword duplication" in a single column. Please recommend me your video about that.
For example in A column there is a name written "Baby hammock in black"
If i write in another row "hammock baby in black" Then excel should tell me this combination is already in Colum
Please guide me any video about this

[@Innozant]

Thanks..kindly share your Excel sheet with query explanation @innozantofficiap telegram id

[@naeemkhan-tm9hx]

Superb

[@Innozant]

Thanks Naeem sahab

[@sekharispassion]

Sir,
You have posted around 6 videos of Conditional formatting.
Will practise seeing them along with this.
Thank you.

[@Innozant]

Yes dear..Keep learning

[@moinusaifi3164]

Super 🔥🔥🔥

[@Innozant]

Thanks

[@BhagwatiDave720]

Too goodsir

[@umeshroy6898]

Please start vba series sir

[@Innozant]

After BI

[@shabbiransari7584]

What will be the condition if we want to do for names rather than months.

[@AliAli-xx1ry]

Bro , use match formula

[@rahulrakshe1988]

Nice teached but pl upload the excel for practice purpose....I didn't got from your drive

[@Innozant]

Comolete exercises are there ,you may download it form video description

[@AliAli-xx1ry]

Dear Sir,
Kindly upload VBA course beg to adv

[@Innozant]

👍

[@swatikushwah842]

I have one quarry about conditional formatting can you solve my problem

[@Innozant]

@innozantofficial telegram bid per bhejen

[@swatikushwah842]

Meri problem ye hai ki ek excel sheet me per day person ke working hours add hona chahiye or add ho to minimum value me colour green ho or usse Kam ho to red ho or ye condition me 1-10 days ke working hours ka total bhi ho or colour bhi ho

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks Gaurav Ji

[@Anil-se9wp]

Hi sir, libre office calc videos please....

[@Innozant]

Ok .

[@m.n.953]

Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF).
I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red.
How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.

[@Narendar.pathak]

Good morning Sir
Conditional formatting is a great toll and i think one or two video not sufficient to explain all thing in this ....anyway thanks for the recap surely iy this will helpfull for us

[@Innozant]

Yes Narender ji..Please lear CF concept from playlist basic excel videos.

[@Narendar.pathak]

@@Innozant thanks

[@rajender811]

How in Google sheets ?

[@rohitpatil2307]

Dear sir
Please provide self conditioning formatting link video.

[@Innozant]

Kindly watch Basic excel playlist

[@durgeshrai8938]

🙏🙏🙏

[@pa2happiness13]

💞👌🏼

[@Innozant]

Thanks

[@krishnakumarkrishnapillai8216]

Ineteresting video, how can we do for an amount or any date instead of month

[@sharafatalimalik7295]

Dear I need your help main Chahta hoon Kay vlookup say data lookup kar Liya ab jo data result main aya hai usko edit karo tu Data update hoo jaye Apni location per?

[@Innozant]

Sheet share kriye telegram bid par @innoxantofficial ..

[@krishnakumarkrishnapillai8216]

Hi sir interesting video, i wish to learn more about excel, how can i reach you, please let me know sir

[@Innozant]

Thanks,You may visit Innozant website or call/whatsapp us for more information

[@satishmestry5687]

Sir please 1 video bpo ke interview me puchhe jane vale excel test ke upar bhi banaiyega. Mai 2 company me interview ke liye gaya tha. But unhe VBA and experience person chahiye tha. Freshers kaise apply kare MIS post ke liye.

[@Innozant]

Aisa nhi hai ki har jagah VBA hi chaiye .advanced Excel par bhi kai mis executive post ke liye opening aati hai .,addon yadi aapne SQL kar liya aur bia nd VBA to wo additional skills hai aapka .

[@satishmestry5687]

@@Innozant but sir maine excel test di thi or unme se 80 to 85 % question solve kiye the. Kuchh alag hi question the bpo se related vo mujhe samjh nahi aaye. Fir unhone kaha ki we need experience person.

[@Innozant]

Question alag nhi data set bpo ka hoga uske base par formula apply Krna hoga dear.

[@satishmestry5687]

Ok sir.
Thanks for replying

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️❤️

[@RahulChauhan-ll9pu]

🙏🙏🙏🙏🙏🙏🙏

[@Innozant]

Thanks

[@deepeshrathore3875]

SIR THODA BATA DIYA KERO CON SA KI USE KIYA HAI AND MONTH BALE FORMULA KO FREEZE KERNE KE LIYE

[@Innozant]

Basic excel series start se Seekhiye random video mat dekhiye..F4 use Kiya hai freez karne ke liye

[@muttiurrehman1579]

I need link for video sir sumif formula in Multiple Tables

[@Innozant]

Apko check Krna hoga...aise yaad nhi hai link dear

[@muttiurrehman1579]

@@Innozant mostly videos dekhata hon appki but nazar ni a i mujy kahi par

[@kanha565]

Sir Practice file direct download link dijiye

[@Innozant]

Dear Direct link sabka tha but pta nhi broken ho gya hai .dubara krtabhu kisi din free hoke saare link generate

[@ubaidillahmuhammad20]

The link description update, sir

[@Innozant]

Updated

[@rajatpatel6599]

Sir, main fresher hu ,koi company wala fresher ka nahi leta , main experience gain karne ka liya kaha sa work start karu.

[@Innozant]

Aisa nahi hai Rajat ji .Fresher based interview bhi aata hai dear.

[@RahulChauhan-ll9pu]

Sir sheet ka Direct link share kr diya karo

[@Innozant]

Direct link below ken ho gya hai dear..kr denge use theek..master assignment hai Already

[@kamran2265]

Sir kabi awoo naa baba Gurru nanak

[@Innozant]

Sure dear Kamran..Jarur aayenge Nanak ji ne chaha to..God bless you dear..

[@ahmedwrites309]

Excel to mujhe programming se bhi zata tough lagta haj 😂

[@Innozant]

Hahaha

[@spdas5942]

Should be more clear sir . My formula directly gives numers for months . And I was confused . A little careful please .

[@Innozant]

Didn't get you,Kindly explain your query

[@workoutschannal7902]

Sir ji subscriber tho dekha do ab tho pls

[@Innozant]

Oh..wo the main Dhyan bhi nhi deta..😀❤️

[@AnuragSingh-w7g]

सर, कहाँ से इतनी बुद्धि लाते हो

[@mamalik1088]

No one match with u as per knowledge

[@Innozant]

Thanks Arshad Sahab
God bless You

[@mjaved701]

Excellent 🤗🤗🤗🤗

[@Innozant]

Thanks dear