Conditional formatting On/Off button in excel | Amazing Conditional formatting in advanced excel

Conditional formatting On/Off button in excel | Amazing Conditional formatting in advanced excel
#contitionalformatting #msexcel #advancedexcel #computergyanguruji
Practice File download link
drive.google.c...
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

[@Itisme177]

ITNA SOFT, CLEAN ,MAKING EASY TO UNDERSTAND.... WOOOOOOOOHHHHH

[@deshdeepakgoel1024]

सर जी आप तो गुरुओं के गुरु हो, आप जैसा सिखाने वाले मिल जाये तो आदमी मास्टर बन जाये। मैं तो फैन हो गया आपका

[@nitintalhan8191]

मनोज सर, आप जो पढाते है वह बहोत अच्छी तरह से समझता है.

[@ashrafhasan5256]

You are really a great teacher sir , I haven't seen before such a great teacher like you...🙏

[@immucool5265]

Sir your explanation is totally understanding and great teaching method keep It up

[@venkatiyer7459]

Process explained in very easy way... thanks Sir

[@3starbunnies559]

Love u dost Mari problem Hal kr di thnk os mach .

[@khureshiabraam6547]

Super 👏👏👏

[@francedurandi5093]

Thank you sir manoj kumar for your great contribution and explanations

[@RavindraSingh-qu9ye]

Bahut acha sikhaya guruji aapne.

[@nisikantbehera5002]

Thankyou guruji bahut acha video hai ❤❤

[@jitendrabomble2218]

Very useful video.
Thanks sir.
👌👌👍👍🌷🌷

[@francedurandi5093]

O, sir, you are extremely great. Your explanations are simply very helpful and greatly appreciated.

[@shishupalsingh3097]

Great lesson, I thoroughly enjoyed it.

[@g.k.8572]

Happy teacher's day, sir, you are such a great teacher.

[@songlistener2509]

Wow...Great learning from this video

[@aflahbargir6884]

Perfect guru ji,thank you so much

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@fakheralam8299]

very easy concept to learn

[@PNRLakshmisilks-f2n]

great teaching

[@ComputerGyanGuruji]

Thank you!

[@sudiptabanerjee5655]

Very good represent thank you❤❤❤

[@sumanpaul1286]

GREAT👍
GREAT👍👍
GREAT👍👍👍

[@taizoondean689]

Thanks sir

[@ManoMani-r1y]

Bottun ke undr agar banana ho ke konsa fail ha grade main batain

[@tomcruize4283]

Thank. You sir ❤

[@nikhil8871436480]

Awesome tutorial

[@faisalshaikh3600]

बहोत achha sir ji

[@vijaysahal4556]

nice sir 👍🏻👍🏻👍🏻👍🏻

[@sumitpanday2378]

Beautiful sir .... Thank u

[@nitintalhan8191]

मनोज सर, मै लगातार 15 दिन से व्हिडिओ देख रहा हूं, आपका पहिले तयार किया हुआ व्हिडिओ से लेकर आज तक जितने व्हिडिओ बने कृपया उनके लिंक दे दिजीए. तांकी मुझे conditional formatting aur सभी छोटी बडी बाते अच्छी तरह से समझ सके.

[@malikzeeshan156]

salam sir
sir make a video ( how to Write specific text in a cell by conditional formating

[@ravidattkumar6153]

so nice,

[@sushilbiswas1640]

excellent

[@rahulpahchal2646]

Very nice

[@kuldeepchandra9148]

mast sir jii

[@mdks1012]

Awesome!

[@haragopaltata8411]

Super Sir.

[@amitsoman203]

Thank you sir

[@Shrutigoyal-u7j]

Exllent

[@hemantkumarmahanand6462]

More video like this

[@satyam0504instaid]

Amazing

[@mohammedhashim7994]

Hello , I am from Kerala, and regular viewer of ur video..Each videos are very interesting and informative. Can u upload a video about details about IF AND NOT ...
Function...I mean how can use , "" ( ) fully detailed class.. Thanks

[@themahiworld13]

Superb video sir.
Sir VBA programming ya SQL programming par video banaiye sir

[@ComputerGyanGuruji]

sure i will

[@deviprasadchakravarty5510]

It was amazing!

[@PrinkeshLimbachiya]

verry good👌👌👌👌🙂🙂🙂🙂👌👌👌👌🙂🙂👌👌👌

[@ComputerGyanGuruji]

Thanks a lot 😊

[@guldastkhan2154]

Best

[@bairaGi_AkB]

Darun

[@rameshmeena7582]

सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।

[@ComputerGyanGuruji]

i will try

[@rameshmeena7582]

@@ComputerGyanGuruji I wait

[@jeraldthalaiva85]

Sir,
How to hidden conditional formatting rules in excel?

[@devibhavsar4195]

Nice

[@donbosco7535]

Good work

[@surendrasagar8380]

Sir Nice video

[@sachintyagi2003]

good

[@RATANAGARWALITINFORMER]

thx sir

[@islamjohir279]

nice

[@kakarlamurali1212]

Useful vi

[@saleembukhsh7682]

Nice trick

[@swapanbishayee7433]

You are right, but I couldn't clear the conditional formatting portion properly.

[@rajnikantpatel7232]

how can increase or decrease cell value by 0.01 with up-dn arrow key in excel cell. just like share trading app Odin buy-sale cell

[@apeduworld7004]

Nice explain

[@ComputerGyanGuruji]

Thanks for liking

[@mohammadahmed7932]

Weldone ,How can i format a part of a row using multiple criteria with sumproduct formula. Thanks

[@paramjeet975singh3]

Badiya tha sir.... Sir ap sql server ni karate??

[@sridharkrishnappanavanerth3388]

I want to show sum in cell c3, for Start date to any future date or start date to last date keeping last date as default end date ( last date should automatically be inserted.) can we do this?

[@anilkoli7274]

In a single cell I want to calculate 10+20+30 and the answer should appear into the next adjacent cell. (kindly make video on this topic)

[@munnaap4679]

how to use ON/OFF BUTTON conditional formatting in LibreOffice thx

[@viralpandya3236]

Sir, thanks...
Conditional formatting Good Teaching through advance...
I am getting more better Knowledge your video.

[@nitintalhan8191]

मनोज सर, नाम मे गलत या फिर value मे गलत ईन सभी को करेक्ट करने का conditional formatting formula बताओ.

[@nitintalhan8191]

मनोज सर, attendance sheet me त्यौहार की छुट्टी और गव्हर्नमेंट छुट्टी कैसे दिखाते है ये बताओ.( नितीन ताल्हन - नागपूर).

[@tariq3134343494]

Hi Sir,
I have an Excel sheet it has lots of formulas and conditions. its also protect. but i just want to get some knowladge about only one condition. if you would like to help me i can share it with you.
Best Regards
Muhammad Tariq From pakistan.

[@safikue]

TX sir

[@ComputerGyanGuruji]

All the best

[@lalitkumarpandey5911]

Hi, I am struggling to apply the conditional formatting based on other cell values. Kindly help.
The case is, in one column I have qtrs. like Q-1, Q-2, Q-3 Q-4 and in other column there are branch codes and these branch codes are repetitive based on some activities. I want to highlight only those cells of branch codes column which are repetitive in that qtr. only.
Suppose if I filter out Q-1, it will show only those cells which appear more than once in Q-1 only and likewise in other qtrs.

[@rasheduzzamanrashed6185]

bro amar a b o c column e data ase ami chassi je a column er data jodi delete kori tahole b o c column er data o delete hole jabe. How

[@RSK90]

How can I contact you ?

[@ammarsaleem1873]

Hi Sir,
I want to apply same button technique on my salary sheet. .
Employee A Employee B Employee C

Gross Salary 100,000 Gross Salary 120,000 Gross Salary 130,000
Basic Salary 62,500 Basic Salary 75,000 Basic Salary 81,250
If Basic Salary is 0 to 50,000 give 50% Bonus
If Basic Salary is 50,001 to 70,000 give 30% Bonus
If Basic Salary is 70,001 to 100,000 give 20% Bonus
Please guide me how can I apply the same Technique using Conditional Formatting using button.
Thanks.

[@iznakhan5868]

Hello sir! Can you please help me how can I download Ms office 2013 on my laptop, for free? Please help 🙂

[@ComputerGyanGuruji]

go to microsoft official website and download it
www.microsoft.com/en-us/download/details.aspx?id=56180
and watch our video for activate ms office full version

[@iznakhan5868]

@@ComputerGyanGuruji sir video reference de dijy please.

[@sunilbhirud3817]

Sirji namskar,मेरे हाथ के नाखून अपना कट हो रहे है कृपया उपाय बताए

[@kavitanawale4928]

Sir excel 2007 formatting

[@ComputerGyanGuruji]

2007 me bhi same to same hoga

[@niteshdudhankar4733]

File do sir practice ke liye

[@sethushankaranmadhavanmadh6712]

Equalize pronounciation

[@joke-spot8259]

sir ji excel mai jb zero likhty hai waha zero nhii ata hai

[@ComputerGyanGuruji]

use single cot (') before 0

[@joke-spot8259]

@@ComputerGyanGuruji
sir please kaisay kha par (')karna hai sir jb mere ko likhna hotaa hai marks 06 jb likhta hoi waha par srf 6 ata hai 0 kha jata hainpta nhii
plx reply

[@apeduworld7004]

Whatsapp group banaye

[@sadhanamishra6416]

Sir aap ke video ko view kyo Nahi मिलता है समझ में नहीं आ रहा है

[@ComputerGyanGuruji]

samajh me mujhe bhi nahi aata

[@ComputerGyanGuruji]

thanks

[@rammotivational9028]

Sir mujhe No. Chahiye apka

[@ashiquetadavi963]

Send new

[@IrfanKhan-wv8rh]

superb sir and thank you so much!!!

[@RSK90]

Very nice

[@lad1059]

nice