Conditional Formatting with formula || Highlight Row using formula || Basic Excel Series

Guy's This is a very interesting topic How to highlight rows using excel conditional formatting. here I am using a formula to highlight a particular row when you select any name from the list.
For Practice File Link is here :
drive.google.com/open?id=1lKc...
#ConditionalFormatting
#ExcelConditionalFromatting
#ExcelFormatting
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My RUclips Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Watch other Videos :
Excel Basic to Advance Series : • Excel tutorial || Exce...
Excel Amazing Features - • समय बचाना है तो सीखो य...
Excel Advance 100 Videos - • Excel Introduction In ...
Excel VBA Series in Hindi- • What is VBA in Excel? ...
Excel MIS Videos - • ये सीखने के बाद एक्सेल...
AUTOCAD SERIES : • ऑटोकैड सीरीज अब हिंदी ...
Technology Videos - • Interview Preparation ...
Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
Tags - Conditional Formatting with formula, Highlight Row using formula, Basic Excel Series, Excel Basic Lectures in hindi, Learn Excel in hindi, Excel Basic Series in Hindi

[@Learn_More_Pro]

Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/

[@bimalkumarnayak6614]

Bht Se Video Dekh Liya RUclips, Sab Bss formula Aur Conditional formating sikha Rahe The, lekin Data Validation use karke woh woh Type of Bottom Kaisa Creat karna hai woh koi nahi sikahraha tha Thank you sir apne sikha Diya

[@Rahulkumar-ye9tu]

Thank u sirji bahut hi shandar video tha....

[@akashshrivastav7359]

Sir thnku so much apki es video ki wjha se muje condition formating ki good knowledge mil gyi.

[@syedasif1101]

Nice & informative video beyond that the way of anchoring in a jovial way is commendable.

[@Princia_dance123]

THANKS SIRJI...I LIKE THE WAY YOU ARE TEACHING AND I LEARNT MANY THINGS FROM YOUR VIDEOS...

[@hv3300]

You rock Satish. Thanks for providing link to download practice file.

[@islamkiroshnisabkliay1470]

Zabardast andaz aur zabardast vdio thanks alot sir

[@sirajmaseed5599]

Sir bahut khub bahut acha babut zabrdast wow

[@manishabhagare4954]

This is your best video ever.

[@PanchayatTeacher]

Gazab............. Video Guru.........

[@sonalikundu4981]

I like this vedio , I learn something new ,thank u sir

[@lokeshawasthi1352]

Mazedar mere liye bahut fhayde wala bahut data hota tha

[@VikasKumar-km1mo]

Sir it's very useful ...thanks and regards

[@amanullahjasor559]

Very good and very useful
Thanks Sir

[@ajaykumaryadavyadav507]

Very useful video sir thank so much

[@Tagore25509]

Very nice and informatie Sir. Keep going on

[@Raman.03]

Teaching method is excellent

[@sanjoyroy7490]

Excellent Satish Bhaiya

[@gautammishra4219]

You are father of computer sir
Amazing video sir
Thanks sir

[@krmotion1522]

me shoch raha tha ki ....maths table ko easily yaad rakh ne ke liye.......
muje ye trick jan ni he......
or children ko .......bohat easliy math tables ko dekh sake or shikh sake.......
ab aap he sab........
please help this trick .....
india ko aap ki is trick ka intjar rahega ......
or muje bhi....
☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️☝️

[@sandeepsingh-jf5qb]

thanku sir for making this helpful video

[@Being_Manish]

Super osm bro...👍👍👍👍👍

[@romanov1124]

Thank a lot for such an informative video. Request you to please make video sound alert with the same condition

[@pravinsingh4087]

u r great sir,

[@mrraibag1559]

Very help full

[@sapnanagar414]

Supper video concept 👌👌👍👍 Bast

[@vaishalisharma9451]

Gajab💯👏👏👏......

[@mesxyz8755]

HEY SHATISHBHAI THIS IS EXCELLENT REMEMBER AT THE BEGING I ASKED YOU ABOUT MY PAYMENT SYSTEM THIS CAN BE USEFUL TO THAT PROJECT IF AND WHEN I HAVE TIME I MAY IMPLEMENT THIS THERE ARE TWO VIDEOS THAT ARE USEFUL TO THAT ,IN THE ECXEL BASIC SERIES THAT YOU YOU ARE GENIUS SHATISHBHAI ,THIS WELL DESERVED SEVEN STAR .⭐️⭐️⭐️⭐️⭐️⭐️⭐️👍👍👍👍👍👍👍👌👌👌👌👌😀

[@Learn_More_Pro]

THANKS MOOSAJI THANKS A LOT FOR WATCHING .....AND I WILL TRY TO MAKE SUCH USEFUL LECTURES

[@nitinkumarbairwa1843]

Very very very useful video

[@kiranbandekar2434]

khup chhan Buavu

[@deepaksinghmotivationalspe2992]

Super video guru

[@iloveindia07860]

Satish excellent your video

[@manjit.sarania]

Very good teaching sir

[@mantumajhi740]

Very so much thanked sir

[@ramizraza7820]

Thank u Si, bohot accha video

[@SinghDavinder007]

Very nice sir...

[@ashishkumarpal454]

Very nice video sir👍

[@laraibejaz4740]

Thanks a lot sir

[@ASINSTRUTECH]

Good information dear

[@amarduggal6834]

Thank you sooo much sir

[@Gaming_With_Red_Devil]

3year phele ke sir or 2022 ke sir me bhut difference hai 😁😁

[@bks654]

Bahut acha video h

[@surajkumarsinha6146]

Very informative

[@GOVINDZONE]

Thank u sir is video k lie

[@prashantdeshmukh2290]

Nice thank u sir

[@vijaykawde4251]

Very good 👍

[@md.taifuranam7904]

Nice presentation

[@dhananjaykumarsingh2695]

Very nice vdo...

[@chandrasekharsahoo5272]

Excellent sir

[@ManojGupta-nl8fj]

Sir aalpke excel video bahut hi upyogi hai. Bhut bahut dhanyawad. Sir kya kisi excel workbook me lage hue sabhi formulas ko copy pest special kiye bina hataya jaa sakta hai (value bani rahe kewal formulas hat jave.) Aisi koi trik ho to batane ka kasht kare

[@ivp2264]

Aapke video se maine shikha.

[@jibankrishnanag4765]

Thanks for your teaching. Sir, I want only cell to be highlighted.

[@bhaktilife5856]

Very useful thx for this

[@pankajpal7340]

So fantastic si

[@sanjaychad9594]

Superb💙

[@miileeuko143]

Good job sir

[@praveengayakwad2579]

Very nice guru

[@PuranKumarBhuwanta]

Excellent

[@WorkVisaProcess]

Bahut achha sir

[@Learn_More_Pro]

Thanks sir for watching this video....

[@user-ww3ik8uq6p]

Nice 1 Sir

[@badruddinrahmani]

Thanks sir,

[@bimalbiswas6121]

Hello sir...
Nice video

[@soyebabbas9194]

Gajab sir

[@manishpandey2828]

Super🙏

[@vtoon3071]

VERY OSM VIDEO

[@gulabsindhi7358]

sir i can do it thnkx u u r the best

[@tabsum9235]

Very nice sir

[@rajeshchoudhary2520]

Very Nice video

[@AwadheshKumar-hv6em]

Very good video👍

[@Learn_More_Pro]

Thanks brother......

[@Raider_Bhai_UP_wala-th8ui]

Very Nice Sir G

[@sonaligarg573]

Thanks sir

[@Amandeepsinghkatodia94]

VERY NICE

[@dineshna7902]

Can conditional formatting is possible with dates viz as targat date is approaching, colour of concerned row(s) containing relevant information be kept changing to show it's urgency.

[@ranibedi5279]

Great sir

[@lipsaofficial1274]

Amazing

[@mohammediqbalkundi766]

kamal ke video

[@krunalk5601]

THANK U SIR

[@sanjanagupta1438]

Nice bhaiya

[@zeerakkhan6980]

need help !!
I want to highlight the row whenever I type "QC", and not all the cells in that row, want to highlight only those cells in that row which are filled.
please guide!

[@ranjitmallick21]

Thank you

[@ibrahimgangawali5752]

Awesome

[@bharat4247]

Great

[@dastageera9626]

Nice..

[@bijaytanty8434]

Good 👍

[@mohd.shahzad9340]

Very nice

[@mygodstutas4467]

Osam Sir

[@jadavprakash9494]

Thanks

[@bhartifirstrankacademiccla4230]

bhot achhaa

[@saketkumar2172]

Good video

[@SunilYadav-je9ky]

Nice video sir
Sir database ke baare me btaiye

[@dikshapandey2705]

👍👍👍👍👍keep it up

[@rakeshkumarpagi873]

Nice video bhai

[@azeemplans179yt8]

great work very helpful

[@Learn_More_Pro]

thanks sir for watching this video.............

[@rina1592]

Mr. Satish, what if I have to get that particular highlighted row [ i have large data] when i select the name it should highlight as well as point to that row? for e.g if the selected data is in row b500, pls provide your expert solution. Thanks.

[@Learn_More_Pro]

here is the solution for this i have already upload video for this please check you will get your answers- ruclips.net/video/tEWu5cZWlg4/видео.html

[@arijeetkumarsharma226]

Superb

[@creativity1687]

shandar sir

[@Learn_More_Pro]

Thank you!

[@sami-sv6nj]

Gjb

[@prabhatmishra6813]

Dear sir. Please sugess me what is the maximum scale font printable in excel sheet (when it's a large sheet) . It's urgent please.

[@shashikantchaudhari1378]

एक्सलेंट सर ।