Тёмный
No video :(

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

Computer Gyan Guruji
Подписаться 402 тыс.
Просмотров 79 тыс.
50% 1

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

Опубликовано:

 

20 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 98   
@deshdeepakgoel1024
@deshdeepakgoel1024 3 года назад
सर जी आप तो गुरुओं के गुरु हो, आप जैसा सिखाने वाले मिल जाये तो आदमी मास्टर बन जाये। मैं तो फैन हो गया आपका
@nitintalhan8191
@nitintalhan8191 5 месяцев назад
मनोज सर, आप जो पढाते है वह बहोत अच्छी तरह से समझता है.
@Itisme177
@Itisme177 Год назад
ITNA SOFT, CLEAN ,MAKING EASY TO UNDERSTAND.... WOOOOOOOOHHHHH
@user-li6dy6bs6p
@user-li6dy6bs6p 10 месяцев назад
great teaching
@ComputerGyanGuruji
@ComputerGyanGuruji 10 месяцев назад
Thank you!
@ashrafhasan5256
@ashrafhasan5256 2 года назад
You are really a great teacher sir , I haven't seen before such a great teacher like you...🙏
@RSK90
@RSK90 Год назад
Very nice
@ravidattkumar6153
@ravidattkumar6153 Год назад
so nice,
@venkatiyer7459
@venkatiyer7459 Год назад
Process explained in very easy way... thanks Sir
@nisikantbehera5002
@nisikantbehera5002 8 месяцев назад
Thankyou guruji bahut acha video hai ❤❤
@immucool5265
@immucool5265 Год назад
Sir your explanation is totally understanding and great teaching method keep It up
@RavindraSingh-qu9ye
@RavindraSingh-qu9ye 3 года назад
Bahut acha sikhaya guruji aapne.
@francedurandi5093
@francedurandi5093 3 года назад
Thank you sir manoj kumar for your great contribution and explanations
@taizoondean689
@taizoondean689 3 года назад
Thanks sir
@sumanpaul1286
@sumanpaul1286 Год назад
GREAT👍 GREAT👍👍 GREAT👍👍👍
@francedurandi5093
@francedurandi5093 3 года назад
O, sir, you are extremely great. Your explanations are simply very helpful and greatly appreciated.
@nitintalhan8191
@nitintalhan8191 5 месяцев назад
मनोज सर, मै लगातार 15 दिन से व्हिडिओ देख रहा हूं, आपका पहिले तयार किया हुआ व्हिडिओ से लेकर आज तक जितने व्हिडिओ बने कृपया उनके लिंक दे दिजीए. तांकी मुझे conditional formatting aur सभी छोटी बडी बाते अच्छी तरह से समझ सके.
@jitendrabomble2218
@jitendrabomble2218 3 года назад
Very useful video. Thanks sir. 👌👌👍👍🌷🌷
@shishupalsingh3097
@shishupalsingh3097 Год назад
Great lesson, I thoroughly enjoyed it.
@g.k.8572
@g.k.8572 3 года назад
Happy teacher's day, sir, you are such a great teacher.
@aflahbargir6884
@aflahbargir6884 3 года назад
Perfect guru ji,thank you so much
@songlistener2509
@songlistener2509 3 года назад
Wow...Great learning from this video
@Kingpotash
@Kingpotash Год назад
Darun
@fakheralam8299
@fakheralam8299 2 года назад
very easy concept to learn
@IrfanKhan-wv8rh
@IrfanKhan-wv8rh 2 года назад
superb sir and thank you so much!!!
@sushilbiswas1640
@sushilbiswas1640 Год назад
excellent
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 года назад
Thanks sir very helpful video
@faisalshaikh3600
@faisalshaikh3600 3 года назад
बहोत achha sir ji
@satyam0504instaid
@satyam0504instaid Год назад
Amazing
@shrutisingla6551
@shrutisingla6551 11 месяцев назад
Exllent
@guldastkhan2154
@guldastkhan2154 Год назад
Best
@mdks1012
@mdks1012 2 года назад
Awesome!
@nikhil8871436480
@nikhil8871436480 3 года назад
Awesome tutorial
@hemantkumarmahanand6462
@hemantkumarmahanand6462 2 года назад
More video like this
@haragopaltata8411
@haragopaltata8411 2 года назад
Super Sir.
@RATANAGARWALITINFORMER
@RATANAGARWALITINFORMER 2 года назад
thx sir
@tomcruize4283
@tomcruize4283 2 года назад
Thank. You sir ❤
@sachintyagi2003
@sachintyagi2003 Год назад
good
@sudiptabanerjee5655
@sudiptabanerjee5655 3 года назад
Very good represent thank you❤❤❤
@devibhavsar4195
@devibhavsar4195 3 года назад
Nice
@sumitpanday2378
@sumitpanday2378 3 года назад
Beautiful sir .... Thank u
@lad1059
@lad1059 Год назад
nice
@kuldeepchandra9148
@kuldeepchandra9148 3 года назад
mast sir jii
@donbosco7535
@donbosco7535 3 года назад
Good work
@malikzeeshan156
@malikzeeshan156 Год назад
salam sir sir make a video ( how to Write specific text in a cell by conditional formating
@kakarlamurali1212
@kakarlamurali1212 3 года назад
Useful vi
@vijaysahal4556
@vijaysahal4556 3 года назад
nice sir 👍🏻👍🏻👍🏻👍🏻
@surendrasagar8380
@surendrasagar8380 3 года назад
Sir Nice video
@deviprasadchakravarty5510
@deviprasadchakravarty5510 3 года назад
It was amazing!
@saleembukhsh7682
@saleembukhsh7682 3 года назад
Nice trick
@rameshmeena7582
@rameshmeena7582 3 года назад
सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
i will try
@rameshmeena7582
@rameshmeena7582 3 года назад
@@ComputerGyanGuruji I wait
@mohammedhashim7994
@mohammedhashim7994 2 года назад
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
@apeduworld7004
@apeduworld7004 3 года назад
Nice explain
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
Thanks for liking
@themahiworld13
@themahiworld13 3 года назад
Superb video sir. Sir VBA programming ya SQL programming par video banaiye sir
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
sure i will
@user-jz8cw8zf1o
@user-jz8cw8zf1o Месяц назад
Bottun ke undr agar banana ho ke konsa fail ha grade main batain
@paramjeet975singh3
@paramjeet975singh3 3 года назад
Badiya tha sir.... Sir ap sql server ni karate??
@swapanbishayee7433
@swapanbishayee7433 Год назад
You are right, but I couldn't clear the conditional formatting portion properly.
@safikue
@safikue 3 года назад
TX sir
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
All the best
@PrinkeshLimbachiya
@PrinkeshLimbachiya 3 года назад
verry good👌👌👌👌🙂🙂🙂🙂👌👌👌👌🙂🙂👌👌👌
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
Thanks a lot 😊
@anilkoli7274
@anilkoli7274 3 года назад
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)
@nitintalhan8191
@nitintalhan8191 5 месяцев назад
मनोज सर, नाम मे गलत या फिर value मे गलत ईन सभी को करेक्ट करने का conditional formatting formula बताओ.
@nitintalhan8191
@nitintalhan8191 5 месяцев назад
मनोज सर, attendance sheet me त्यौहार की छुट्टी और गव्हर्नमेंट छुट्टी कैसे दिखाते है ये बताओ.( नितीन ताल्हन - नागपूर).
@khureshiabraam6547
@khureshiabraam6547 Год назад
Super 👏👏👏
@mohammadahmed7932
@mohammadahmed7932 2 года назад
Weldone ,How can i format a part of a row using multiple criteria with sumproduct formula. Thanks
@munnaap4679
@munnaap4679 3 года назад
how to use ON/OFF BUTTON conditional formatting in LibreOffice thx
@viralpandya3236
@viralpandya3236 2 года назад
Sir, thanks... Conditional formatting Good Teaching through advance... I am getting more better Knowledge your video.
@sridharkrishnappanavanerth3388
@sridharkrishnappanavanerth3388 2 года назад
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?
@sethushankaranmadhavanmadh6712
Equalize pronounciation
@lalitkumarpandey5911
@lalitkumarpandey5911 5 месяцев назад
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.
@niteshdudhankar4733
@niteshdudhankar4733 2 года назад
File do sir practice ke liye
@tariq3134343494
@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.
@ammarsaleem1873
@ammarsaleem1873 8 месяцев назад
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.
@kavitanawale4928
@kavitanawale4928 3 года назад
Sir excel 2007 formatting
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
2007 me bhi same to same hoga
@sunilbhirud3817
@sunilbhirud3817 3 месяца назад
Sirji namskar,मेरे हाथ के नाखून अपना कट हो रहे है कृपया उपाय बताए
@rasheduzzamanrashed6185
@rasheduzzamanrashed6185 3 года назад
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
@RSK90 Год назад
How can I contact you ?
@apeduworld7004
@apeduworld7004 3 года назад
Whatsapp group banaye
@ashiquetadavi963
@ashiquetadavi963 3 года назад
Send new
@iznakhan5868
@iznakhan5868 3 года назад
Hello sir! Can you please help me how can I download Ms office 2013 on my laptop, for free? Please help 🙂
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
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
@iznakhan5868 3 года назад
@@ComputerGyanGuruji sir video reference de dijy please.
@sadhanamishra6416
@sadhanamishra6416 3 года назад
Sir aap ke video ko view kyo Nahi मिलता है समझ में नहीं आ रहा है
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
samajh me mujhe bhi nahi aata
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
thanks
@joke-spot8259
@joke-spot8259 3 года назад
sir ji excel mai jb zero likhty hai waha zero nhii ata hai
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
use single cot (') before 0
@joke-spot8259
@joke-spot8259 3 года назад
@@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
@rammotivational9028
@rammotivational9028 3 года назад
Sir mujhe No. Chahiye apka
@rahulpahchal2646
@rahulpahchal2646 3 года назад
Very nice
@amitsoman203
@amitsoman203 2 года назад
Thank you sir
@islamjohir279
@islamjohir279 3 года назад
nice
Далее
Əliyev və Putin kilsədə şam yandırıblar
00:29
Просмотров 167 тыс.
Excel Conditional Formatting using Formulas
9:23
Просмотров 300 тыс.
MS Excel - Conditional Formatting Part 1
10:42
Просмотров 1,2 млн
Create In-Cell Charts with the REPT Function in Excel
9:35
Most important tools in Excel -  Malayalam Tutorial
17:04
Əliyev və Putin kilsədə şam yandırıblar
00:29
Просмотров 167 тыс.