Data Validation And Conditional Formatting | Excel Drop Down List including cell color change

[@amyaditi3641]

Sir you are "THE BEST TEACHER " over the net. Jitni bhi aapki tarif kare Kam hai. Maine saara excel aapke hi videos se seekha hai. I don't know how to thank you.

[@Innozant]

Thanks dear...Happy Learning ❤️

[@umerkayani79]

You are a gifted person, Sir.. May Allah bless upon you and your family..Ameen

[@Innozant]

Thanks Dear

[@sandeepaswal8944]

Sir Your skill set is something to aspire to. Very knowledgeable, and even more important in this role, an Excellent teacher and communicator. My answer is =IF(OR($A2=$E$2, $B2=$E$2, $C2=$E$2),TRUE,FALSE)

[@Innozant]

Nice attempt...with different logic Tejpal sain Ka comment dekhiye aur unhone Jo answer Kiya hai ek Baar use bhi go through kar lijiye..🙏❤️♥️👍👍👍Good Sandeep.

[@deepakkandpal2602]

=or($E$2=$A2,$E$2=$B2,$E$2=$C2) i used this formula to Conditional Formating.and its working fine. Thankyou sir🙏

[@lkumar2727]

kabhi kabhi lagta h kitna content dekhe....kaash ek book hoti inn sabki....jisme pura practical hota

[@Innozant]

Bana dein book ..ap itne Dil se kehte Hain to collection series Practical Ka..🙂🙂❤️❤️karte jaiye..thakna Nahi hai..dear..khudko itna strong Kar lijiye ki ek waqt ane par apko lagne lgega..isse bahar Kahan se laoge Questions Interview mein..Maine sab Kar rakha h🙂♥️♥️❤️ Chaliye ab jaldi as answr kriye Jo pucha hai... waiting 🙂🙂

[@1gopalakrishnarao]

Excellent. You are igniting the sparks in the minds of the Excel users/lovers/addicts/learners to do some work in Excel. You are creating interest. You are making us to learn how to use Excel for our day to day problem solving. Thanks a lot. Great job indeed. Hope you are going to show some more tricks/tips/utilities to us in the coming videos.

[@Innozant]

Thanks Gopala Sir for such a valuable and wonderful feedback.. Thanks for giving me the reason of motivation t make some good content for all of you.🙏🙏❤️❤️

[@lorenzoelise3121]

Dear they way you teach and explain is amazing and outstanding apart from that your appearance and dressing are always well manner. Stay blessed

[@Innozant]

Thanks Lorenzo Elise for such a lovely ,valuable and motivational comment.. Really mean a lot to me...Thanks dear..Will always keep your words and try hard to deliver awesome content .

[@lorenzoelise3121]

We arr the students of striling University Scotland your videos are helping us a lot to understand the excel although difficult to under the language but our indian friends are aldo helping us. May God blesd you with his knowledge and help you to do good for society

[@Innozant]

@Lorenzo Elise ,Thanks a lot dear, Yes I started making videos for Hindi language audience, Soon will try to add caption to understand english audience as well.

[@sathyanarayana4914]

hii

[@Learn_withkd]

Very informative Sir 👍👍👍👍

[@msexcelgooglesheet374]

Kattai Zaher video sir ji. 😂🙏

[@Innozant]

Hahaha ..wow comment 👍❤️🙏

[@satishojha6240]

Hai bhai khud se try kia hai 2 months se sir ka video dekh raha hu😊😊 tum bhi same formula lagaye ho kya.

[@shahwaizkhan7517]

Love you brother from Pakistan Peshawar

[@Innozant]

Thanks Khan sahab.God bless You dear

[@ta20111996]

Thanks for the amazing teaching.

[@puransingh-sx2tk]

Aaj k class main to maja aa gaya

[@Innozant]

Acha ji...Jo Ques pucha hai uska answer chaiye ..krke dekhiye khudse..🙏♥️👍

[@preetiprajapati4631]

This is awesome sir 🙂 very useful 🙏

[@vishalkumar-qi1ky]

this video is very help full and thank you so much sir.

[@Innozant]

Thanks Vishal Ji.Happy Learning dear❤️

[@manojsable8482]

Usefull data nice massage sir

[@Innozant]

Thanks Manoj Ji♥️♥️🙏

[@naveedmuzaffar7316]

Awesome outstanding marvelous 👌 excellent sir the way of interpretation data in a such simplicity manner with high value it's true sir that your every lecture enhance my productivity of work.sir is there any lecture on financial modeling? Enthusiastically waiting of your kind and response.

[@Innozant]

Ok...noted

[@user-jc6te1vm8v]

sooo talented u r sir.... amazing

[@Innozant]

Thanks dear ❤️🙏 for valuable feedback 🙏

[@Excelpro75]

=OR($A2=$E$2,$B2=$E$2,$C2=$E$2) This is formula sir. I applied it is success.! 🤣Thank you

[@Innozant]

Good 👍❤️

[@shurawat8650]

HELLO SIR LAST VIDEO CONDTIONAL FORMATTING PRACRISE FILE ISNT IN THE PRACRISE FOLDER

[@bishtlokesh1297]

These is useful video nd very helpful ❤️

[@Innozant]

Answer Ka wait ..Jo Ques pucha hai..bataiye Loeksh Ji❤️🙂

[@shrikantbadge3978]

Thank you Dilip sir

[@govindsharma9121]

Sir you are super

[@itzPrincesoni]

Sir, MIS ki information video bnao ek, uska use, etc

[@Innozant]

Already Available hai career guide playlist me

[@rajaalmeida4914]

Very nice

[@Anil-se9wp]

Hi sir,,, excellent demonstration... Libre office calc videos please....

[@Innozant]

Thanks..ok sure will try this make the same

[@muhammadsaqlain5162]

very very nice trick

[@anooparora2515]

Thanks Sir!

[@paras5861]

Zabardast!

[@Innozant]

Thanks Dear

[@meditationmusic6482]

So nice Sir ji.

[@Innozant]

Thanks Sanoj ji..hv a great day

[@meditationmusic6482]

@@Innozant thank 😊 you sir

[@RoshanKumar-uv2ml]

Sir, is qus. Ka ans Bada advance or simple h. 1st IF and IS Blank,0, value error then search formula laga do. Simple. But sir ek bahut complicated quarry h mere paas. Jo ki nhi ho paa rhi mujhse. Agr aapne iss cmnt ka kuch bbi Rply diya to tb m aapse wo puchunga quarry. Pls solve ya rasta dikhne ki krpa krna sir. Ty sir.☺️

[@Innozant]

@innozantofficial telegram id par bhejiye query,Will see

[@azadsingh7452]

This is helpful video

[@kinghundred]

very good sir

[@monirhossainhtbaddagpsnabi8375]

10 or 13 or 17 digit NID number inport furmula ? give me please

[@dakshbachhety97]

Sir I love u 😘

[@Innozant]

Thanks

[@saneeshkrishna3818]

Dear Sir, the below formula for your question =OR($A25=$F$25,$B25=$F$25,$C25=$F$25,$D25=$F$25) for fill the colour =$F$25="" for no fill when the search box is empty

[@Innozant]

👍❤️

[@rajadey1552]

Sir main n ek cell m vlookup 4mula lagaya condition k sath. Ab me chahta hu jaha m vlookup lagaya waha ki condition fullfill ho to formula still rah jaye. Or condition exactly match nhi hoto me ek validation k through us cell ko specific message dena chahta hu.... Matlab sir formula and datavaildation ek sath kaam kare... Kya aisa ho sakta hai. Agar ap k paas koye vdo ho to plz link share kijiye na. Plz🙏🙏🙏🙏🙏🙏🙏

[@AmitGupta-bl2iu]

Best sir

[@RahulChauhan-ts8xt]

Sir conditional formatting data se bina conditional formatting lage data ko kaise separate krein.

[@Innozant]

Filter features ya filter function available hain aapke paas.

[@amitca22]

hi could you please solve this or made a video on data validation of date where column names are order id, order date ,ship mode, shipping date apply data validation on shippng date where shipping date is after or greater than order date.

[@smitadivarekar1475]

Thank you sir....

[@Innozant]

Thanks

[@heartpirates-qt6ws]

the formula of this question is =if(isblank($e$5),0,search($e$5,a5&b5&c5))

[@amandeepbadgujjar7096]

Hello sir good morning, sir mene question ko solve kiya leki jis cell me search karna h uske background me bhi colour show kar raha hai mera answer IF(OR($B2=$E$2,$B2=$E$2,$B2=""))->last vala colour ke liye h. Sir ye sahi h n or sir background ka solution bhi bata di giye 😇😇😇

[@chowdhurysunzidmahbub79]

How to increase Dropdown font size???

[@devendergusain8974]

thnkx sir 200%

[@sawaimalhi8439]

kiya baat hai sir aaap ki

[@Innozant]

Thanks dear

[@krijaygaming3506]

Sir aap bihar me kaha se ho i am from pupri, sitamarhi, bihar

[@Innozant]

👍❤️

[@tjr1421]

Sir ek query hai. Jab source se list copy karke dusre sheet pe paste karte hai to remove duplicate, taki uski drop down list bana sake, tab sir main sheet se validation box jab open karke source me wo list add karne k liye dusre sheet se jaha list bana rakhi hai, excel 2007 allow nahi karta. Do I need to do any setting for this problem?

[@RoshanKumar-uv2ml]

Simple h, koi settings nhi ho skti. Excel uss kaam ko krne k liye nhi bana. Advanced Excel hi kr skta h. Mtlb new 2022 wala

[@tjr1421]

@@RoshanKumar-uv2ml no bro muje solution mil gaya. Excel 2007 me agar hum naming range de toh dusre sheet pe validation box me direct uska name range type kare toh hojata hai.

[@harshadshikerkar6448]

Hi I have trouble in my excel. I have merged 2 rows and 10 columns and then I have given data validation with drop down list. Till this function ok. But after that I have given conditional formating with specific text with specific colour for that merged cell. Then if I choose from drop down list then my cell getting half with different colour and half with another color. And half is not exactly half of cell. It's random Please guide regarding

[@Innozant]

Applied conditional Formatting may mismatch

[@MrRashmimallick]

Sir, Pls help to provide formula for nth match by using vlookup and indirect...You have done for 1st and 2nd match...

[@Innozant]

Ok..will add it in upcoming videos

[@MrRashmimallick]

@@Innozant Thank you Sir

[@MrRashmimallick]

@@Innozant Other day u r telling about the solution through index match and small. Pl also include this in your upcoming videos

[@meditationmusic881]

excel me table me date me 2020_2021 and 2021_2022 ko alag kaise kar sakte hai

[@Innozant]

Didnt get you,Query explain kijiye detail me

[@paramjeet975singh3]

Sir isme underline kaise karege Bold Italic regular Yahi hai Underline wala kaise hoga sir pls batana Thank sir

[@pawanwakale8801]

sir is drop down list ke end me aapne jab select kiya drop down source validation se woh humare isme nhi ho raha woh sheet se dusre me move nhi ho raha isme ruk gye hum ,,kya excel ka koi issue hoga sir yeh

[@Innozant]

Matlab..kya kar re hain to issue aa raha hainye btaiye aap?

[@vishakhavishakha867]

All boder kese lagaya sir

[@Innozant]

Alt h b a Vishakha ji

[@priyankabansal6381]

Thanku sir

[@Innozant]

Thanks Priyanka .🙏❤️Hope you done the Practice of data validation 🙂

[@Brothersvlog-2024]

Sir agar koi employ h or uska hume dikhana h ki agr wo present h to uski present High light ho absent par click kre wo hight light ho kitne din wo office aaya wo count dikhe ..sir ye samajh ni aa raha k ek employ ka sara data uske naam pr click kre to count show ho present pr click kre present High light ho wo ni ho raha sir

[@Innozant]

Anjali data validation list creatw kijiye usme P A aur Total Employee yw likho then highlight karna hai to conditional formatting me jake new rule aur condition apply kriye Using If function.Aap try kriye yadi nhi hota hai aapse to mujhe aap excel sheet share kar dena query likhke ki aap kyabchahte ho.Will guide you for the same. @innozantofficial telegram id par bhejoye.. Dont worry ye bht simple sa issue hai apka ho jayega.❤️🙏 Thanks for being part of Innozant Family ❤️

[@Innozant]

Hua problem solve aapka?abhi bhinydi issue face kar re hain to @innozantofficial telegram id par auery send kren..will guide you

[@Brothersvlog-2024]

@@Innozant ni hua 😭 mene kosis ki bahut employ ka sara data ek jgha show Krna h ...sir jaise hume dekhna h k employ month me kitne din office aaya wo count kaise kre ....sir hume dikhana h k ...agr hum Present pr click kre to present highlight ho jaye absent pr click kre wo hight light ho jaye weekof High light ho ...jitne din aaya office wo aa jaye ..sir ye hm uske name pr click krne par kaise nikale sab

[@Innozant]

@@Brothersvlog-2024 Conditional Formatting se easily kar sakte hain na custom function use karke using new rule,conditional formatting ke advanced video dekhiye aap kar payenge khudse nhi hota hai the sheet format mujhe @innozantofficial telegram id par bhejna

[@AbhishekPandey-je5ql]

Sir first wale formula se, agar bold k baad italic click krte hain to bold chala jaata h, bold krte hain to italic chala jaata h. Please guide

[@Innozant]

Dono ke liye formula apply kriye

[@AbhishekPandey-je5ql]

@@Innozant sir apply dono k liye kiya hai, but ek baar me ek hi lagta h.

[@aaradhanasoni8991]

👌🏻👌🏻

[@shoaibahmed7257]

done

[@user-shubham0333]

Ye to same fruits vle ki trha hi ho gya

[@atulshukal4072]

E2="","",A2 formula Sir

[@pradeepjangid490]

शब्द नही हैं सर तारीफ के लिए

[@Innozant]

❤️❤️❤️

[@pradeepjangid490]

@@Innozant सर मेरी एक query हैं excel की मुझे आपका mail id बताओ ताकि एक सैंपल फ़ाइल भेजकर आपको query बता सकू

[@Innozant]

@innozantofficial telegram id

[@ShyamSundar-mn4vm]

My formula for CF =ISERROR(SEARCH($E$2,$B2))=FALSE

[@SarojKumar-ro7is]

👌

[@Innozant]

Thanks

[@rameshmeena7582]

मैं यह जानना चाहता हूं ।सेलेक्ट एरिया में पूरा डाटा वैल्यू कैसे चेंज होता है।ड्राप-डाउन से। मैं चाहता हूं कि सलेक्टेड एरिया मे ही पूरा डाटा चेंज हो जाना चाहिए। जिस प्रकार "Hide/Show" data मे होता है सलेक्टेड एरिया मे।सलेक्टेड एरिया मे ड्राप-डाउन से पुराना डेटा की जगह नया डेटा आ जाये

[@Innozant]

Sheet share kijiye query ke saath @innozantofficial telegram id

[@rameshmeena7582]

Sir send your Gmail ID so that I can send my file because I do not know run the telegram id

[@ShyamSundar-mn4vm]

You can do it with the help of advanced filter

[@satishojha6240]

We use logical function IF(isblank($E$2),0,Search ($E$2,$A2&$B2&$C2)) I hope ye sahi hoga .Thanku sir for this video good night.

[@Innozant]

👍❤️ good Satish ji

[@gauravbhatia7987]

Ok sir i gotit Select the data a2:c19 Then got the condition formatting and in formula =if(or(a2=e2, b2=e2, c2=e2),true,false) then choose a someone colour and sir isme jo e2 hai vo fix rahega or jo c2, :b2, a2 ka column fix rahege maine apply kiya hai sahi aa or blank cell rakhne se koi condition nhi lgti sir

[@Innozant]

Nice attempt Gaurav,,Aap Tejpal sain Ka comment padhiye aur Jo formula use Kiya hai unhone use bhi kijiye ❤️❤️🙂m really happy ki aplog interest Lete Hain Kuch Acha seekhne ke liye .🙏❤️

[@msexcelgooglesheet374]

Sir ji there is a problem in comment section, One comment is not showing Tejpal saini Jiska comment apne dekhne ke liye kaha hai Confusion where is the comment.. 😕

[@Innozant]

Oho..isi video me to hai niche..koi nhi aap if(isblank($E$2),0,search($E$2,$A2&$B2&$C2)) ye use karna ..ok..good night

[@msexcelgooglesheet374]

@@Innozant thank u very much sir 😀🙏❤️. But comment is not showing sir ji, you can check through in incognito mode not from official channel of innozant.

[@Innozant]

Matlab...All comment is not showing?I am able to see all the comments .

[@msexcelgooglesheet374]

Yes all comments are not showing, You can see through your innozant youtube channel but when you open this video in chrome incognito some of the comment will not be show in comment section. I hope sir ji u got it what i want to say......

[@ishutiwari5567]

@@Innozant sir isse easy formula to mujhe =OR($A2=$E$2,$B2=$E$2,$C2=$E$2) ye wala lga. ye jo apne formula type kiya h isme kuch logic smjh nhi aya. isblank se to 0 value ayegi means "false" ,to kuch highlight nhi hoga.itna to theek h but search function to kuch bhi value de dega according to the position of text.uske base pe kese highlight hora h.i wonder😳 mene evaluate bhi krke dekha formula but logic amjh nhi aya apke wale formule ka.😕

[@jayendratripathi7336]

🙏👌🙏

[@Innozant]

Thanks Jayendra ji👍❤️

[@letsdomistakes]

=OR($B2=$E$2,$C2=$E$2)