Smart Conditional Formatting in excel | Conditional formatting on text | Advanced Excel smart trick

How to highlight particular text in cells using conditional formatting in excel
Smart Conditional Formatting in excel | Conditional formatting on text | advanced Excel smart trick in hindi
#conditionalformatting #msexcelinhidi #advancedexcel #computergyanguruji
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic

[@muhammadarif8006]

Excellent teaching Sir thanks 🇵🇰

[@MrRajeshkumar49]

आपके lessons बहुत ही शानदार होते हैं सर जी

[@kiranmohire5247]

I have been watching your video for many days, and they are helpful in corporate office.

[@arunkumarsinghark3024]

Work को automate करने का Series बनाए, office में बहुत जरूरत है, job भी इसी आधार पर मिल रही, Automate करना सिखाएं l Macro Series, VBA se automate करना सिखाएं l

[@jitendrabomble2218]

Thanks sir.
Very useful information.

[@SmdHamim]

Really nice vedio.

[@kalindirane6668]

Very nice sir.

[@nabeelahmed9297]

Great sir

[@R.R.P.5559]

V. nice manojji

[@jiteshsolanki4880]

Thank you sir ji

[@AbdulKareem-tn5ch]

Very powerful nice

[@ubaidillahmuhammad20]

nice and good job. but please put all excel practiced files in the description....

[@moulavalli5548]

Sir conditional formatting may hightlight Kiya cell ko chod key without highlited cell to delete kaise karey but highlited colour aisey hi rehana hi.

[@kabirvachanupdater7072]

Sir how to highlight intersection of row and column

[@mujahidpoetry4696]

Sr muja installment base pr ek formula pochna tha k pending of month ma agar due date bhi guzar jay to month plus 1ho jay

[@petsworld2618]

Sir number to text convert with macro ki video bana den

[@sumankumar3986]

Nice video

[@politelyhonest5717]

Good class. Thank you

[@electricus_aniruddhachanda8184]

Sir plz suggest me,say I calculating, total Day or day count from Received Date to current date. But if in some particular colloum I type/print "delivered",then this day count will stop immediately. But the last total day count will remain same and it must be display, until I delete it.
Thnx in advance.
Aniruddha.
सर, कृपया मुझे सुझाव दें, मैं प्राप्त तिथि से वर्तमान तिथि तक कुल दिन या दिन की गणना करने के लिए कहूं। लेकिन अगर किसी विशेष कॉलम में मैं ओके टाइप करता हूं, तो इस दिन की गिनती तुरंत बंद हो जाएगी। लेकिन अंतिम कुल दिन की गिनती वही रहेगी और इसे प्रदर्शित किया जाना चाहिए

[@electricus_aniruddhachanda8184]

Sir, kaya is formula "total sum" ka upor bhi applicable hoga ? Say if total sum of cell A + cell B + cell C = sum at cell D is "50" & if tatal sum of cell D is (>50) then print "good" or so on??

[@akriti__]

1:10 yeh same to same kaise colmn. Create kiye bina copy paste ke aur cell mein jo text tha woh bina copy paste ke uss mein chala aaya

[@user-sb1uc3gs7s]

Sir agar Cell A me 23 likha ho and cell B me Good likha ho. Me chahta hoon k agar cell B me Good likha ho to cell A ko hilight kar de. To is ka kia tarika hai

[@anjanutube1]

Custom number format is not taking more than 3 criteria of numbers. If it possible to make 4type of gradation with number formatting?

[@sadasiba8761]

Dear sir
Good Afternoon
Sir I want to know how cell will be highlighted if text may be less than 10 digit or may be greater than 10 digit.
Please suggest formula
With Regards
Sadasiba

[@sharmasatyawan3188]

Sir ek cell ek perticular amt. Se jayada ho jaye to blink ho

[@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.

[@2310546]

How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded

[@user-df9gv4ox8k]

Sir Vlookup k formule k sath space ko add karne wala formula kaise lagaye

[@ComputerGyanGuruji]

HAMNE LOOKUP KE KAFI VIDEO UPLOAD KIYE HAIN EXCEL PLAYLIST ME JAA KAR AAP DEKH SAKTI HAIN

[@sharmasatyawan3188]

Sir mai apko apni file bhejta hoon cell blink ho

[@payghameislam5288]

Chowpat

[@sandeep-vc6pp]

Sri apna no dijiye