5 Conditional Formatting tips to make you a rock star at work 🤘

[@vijayarjunwadkar]

Very cool tips Chandoo! Every time you end up enriching your viewers with something practical and useful! Keep up the great work! 😊👍

[@chandoo_]

Thanks Vijay 😀

[@AnkitSingh-yl3ny]

I am a mis Executive In a organization. After See your amazing Videos now I am developing My Skills Into Data Analyst.. ❣️❣️

[@chandoo_]

Wow.. More power to you Ankit...

[@aiasaiascon3894]

You're the best one in explaining Excel so far, Thanks a million!

[@chandoo_]

You're very welcome!

[@shashankks2454]

This is awesome Sir..! Could you do an Vedio on Interview Qestions in Excel? .....That helps a lot Sir

[@chandoo_]

You are welcome Shashank.. I have an *exciting* video coming up next week. Stay tuned...

[@sarikadatta3706]

You never fail to amaze me. Just too short of time right now but as soon as I am a bit available, I would like to sign up for your excel class. Thanks for the wonderful work

[@chandoo_]

Thanks Sarika... Sure. my course is ready whenever you are...

[@surajbhardwaj428]

Really Awesome 😀.... I need this one on Conditional formatting... Love to hear pop up music🎵 coming in during this video... Nicely arranged video... Thank you ...Sir..👍

[@ramakumarguntamadugu1299]

yes, 👌that pop up music is fun😊

[@chandoo_]

Glad to *hear* that... 😎

[@lenseq]

Best Excel teacher. You give example data sets to download as well as show exactly how it is done. Amazing!!!!!. You make me love excel more and more

[@chandoo_]

You are welcome!

[@daliladuf]

Brilliant as always! Thank you.

[@chandoo_]

My pleasure!

[@natarajangandhi2043]

you are really amazing and down to earth and humble guy

[@bluesage1528]

Great video! I loved the content and the engaging and easy presentation as well!!!

[@chandoo_]

Glad you enjoyed it!

[@Pattacts]

Excellent, excellent, excellent! You are a wonderful teacher!

[@chandoo_]

Thank you! 😃

[@vitruvian_man]

That makes our report look "yummy". LOL I like that.

[@chandoo_]

😎

[@shafkatulalam5275]

Highly overwhelmed getting in touch with you. Wishing for your greater progress.

[@chrism9037]

These were great tips, thank you Chandoo!

[@chandoo_]

Glad you like them Chris...

[@MrVenterW]

Thank you Chandoo. Very informative. Is there a way to compare the values of 2 two rows with each other with conditional formatting to highlight the ones that do not meet the condition e.g. If the customer's days are larger than the supplier's days for a specific month, it should be highlighted. I know I can apply this condition for each month separately, but to do the conditional formating with one formula for the complete row is the preference. Thank you

[@wayneedmondson1065]

Great CF tips! Thanks Chandoo. Thumbs up!!

[@chandoo_]

You are welcome Wayne... 😀😀😀

[@TheShalomc]

Excellent teaching Chandoo. I enjoy learning Excel. Learned a few new things today. 🙏

[@shreyanshdangi4366]

very informative video!

[@jamesgaines6676]

Thanks for the data bar tip! 📊🙂

[@royaldeal6525]

Chandoo my man, real respect for you. Hi! From London.

[@Pankaj-Verma-]

Loaded with value. Thanks for your kind help. Regards.

[@OzduSoleilDATA]

GOOD STUFF!

[@heeralalkumawat2132]

Super to superb

[@maheshwaradatta1587]

very interesting sir great explanation want to learn more excel tips from u sir hope u share more videos 😊

[@mich8261]

This was great. Super helpful to show in incremental steps

[@nolatari]

Helping us to improve as always, thank you.

[@chandoo_]

That is my mission really. Helping one million people every month...

[@hazemali382]

always great, always you present new Technics

[@chandoo_]

You are welcome Hazem...

[@philipjose8092]

Very useful ❤

[@ItsWithinYou]

Super! Thank you for sharing!

[@rmmccarthy1240]

🤘Rock On! Thanks for a great lesson!

[@chandoo_]

😎😍😎

[@diegaah]

Amazing

[@karimibrahim3097]

Wonderful as Always. A new Subscriber

[@chandoo_]

Welcome aboard Karim...

[@Ravz347]

Hi Chandoo !! A question regarding applying conditional formatting in a pivot with multiple slicers. I want a particular cell (Say D4) to show the text in Green when the value is > 0 when we select "Debit total" as the slicer option. However, the same cell should show red show values < 0 & we select "Credit total". Both these data sets will show the final output in cell D4 basis on the type of slicer we select (Debit total or credit total). My question: Can we apply conditional formatting in this same cell to show the text as Green when "debit total" slicer is selected and as Red when "credit total" slicer is selected? Please do note that the range where the conditional formatting needs to be applied is a part of a pivot table. Apologies for the lengthy question !!

[@govindkumardasamantarao562]

How to format those cells whose sum constitute defined % of the total sum? .

[@debbie6085]

Thank you Chandoo. That was great. 👌

[@chandoo_]

Glad you liked it!

[@RaviKumarCreativeCorner]

This is great. Thank you

[@jagatkrishna1543]

Thanks Sir 🙏💕 But what's difference between Excel n Adv.Excel; Requesting Kindly share your knowledge through the Videos

[@Chandan7404]

Lovely Tips!

[@danzirulez]

haha, I thought I knew conditional formatting, then I watched this :) Nice one Chandoo!

[@chandoo_]

Wow. Thanks Danzi...

[@ramakumarguntamadugu1299]

great tip to get more attention from dashboard audience... thank you..👍👌

[@chandoo_]

Glad it was helpful!

[@phugoid]

Splendid video

[@riteshzope3672]

Can use large(cell,3) function to sweet three large cells value.

[@chandoo_]

Great tip 😎

[@riteshzope3672]

@@chandoo_ thanks 🙏🏻 Please make more videos related to advanced power bi

[@m.raedallulu4166]

Excellent! I was to write the same idea!

[@ngosh08]

Great Tutorial.....is there a way of formatting the font size and font type?

[@sshhssaa5091377]

Thanks for video.

[@sanrock21]

I want data depending on cell status i have Active and Closed. So i have data in A,B and in C i have Active or Closed, So If i select Closed then data in A,B should add up and be displayed in column D, how can we do it?

[@muhammadsaadme3017]

Nice sir can u please also make videos on SAP

[@jyothirmaikoka786]

could uoyplease make a video on latitude and longitude in excel

[@dforyou-informativetipstra9012]

Sir my company is using one cash flow excel sheet and once i edit numbers or any data it showing a differennt formate which means i need to make each and every one need to format painter . My question is how to set the whole excel sheet in particular format? If i edit any thing i need it same format before.

[@lokeshbatra6652]

Hi Chandoo, I have a question for you, I want to apply [Color10]0.0"▲";[Red]-0.0"▼"; plus #,,.00 formatting to a single cell how can I do that?

[@grisheldamarks-webster-noa1706]

Hi, how can I hide rows based on a cell value specifically a drop down menu, using excel 2016. Using conditional formatting as an alternate to macros but my version does not have the "hide" option in the "font" tab. Thanks

[@user-ll1ox7xq6x]

As usual awesome...

[@chandoo_]

Thank you so much 😀

[@divakarsingh5103]

Thanks

[@kartavyatiwari8583]

hey chandoko your videos is very nice but your editing is also nice i want to know how you edit this effect on camtasia 3:30

[@chandoo_]

Thanks Kartavya... Here is a brief outline of that edit. 1) Duplicate the screen recording layer and place it on top the original (at exact frame) 2) Crop the second layer (holding down ALT) to just the formula box 3) Add custom animation to the second layer and zoom it up. 4) Add any shadow / highlight effect if needed 5) Restore the animation once the emphasis is over. Hope that helps.

[@abdofeduconsult]

Nice Job 👍. Keep it up

[@chandoo_]

Thanks 😀

[@MrBeadies]

You could have kept the rule of top 3 then added a new rule to the adjacent column which format green based on the colour of your D column. So if it was a top 3 then the other cells in that row will go green picking up the colour change in column D

[@chandoo_]

Hmm.. not sure you can do that. There is no "CF" rule that can change color based on the color of other cells (not yet). Or am I missing something?

[@akhilalanka3861]

hi chandoo, i tried highlighting the top 3 sales using sample document provided. I used the same $B2>150000 ( data starts from 2nd cell, B column) but top 3 data is not highlighted? Can you tell me where I went wrong.

[@morgannaidoo4386]

Hope you can assist. I have data set and the first column is Planning date. i want to conditional format the entire row with colour fill if a date is inserted, if blank nothing happens. Then there is another column Delivered Date. Once a date is entered there is need to over write the Planning date with colour green (entire row) . Please advise if you can advise how this is done, been battling for a while now to get this right. Many thanks

[@chandoo_]

Sure. Assuming your planning date is cell A2, delivery date is in cell F2, select all your data (excluding headers) add a new conditional formatting, formula rule type the rule as =$A2"" and set formatting as red color. Now add one more rule type the rule as =$F2"" and set the formatting as green color This should give you the result you want. If you notice some inconsistencies, go to manage rules and make sure that the rules are in the order of red first then green (so green will always overwrite red).

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

[@theaverageuser05]

How to exclude cells with zero or no values in top bottom rules? Thank you!

[@surajtharali1273]

Hello Chandoo, I am big fan of your work. I wanted to know is there any way to alter the values in formula bar? Eg. I input 10,00,000. Then I convert that value as '1' through some custom formatting as my client wanted to see this value as scaled. Now his requirement is they wanted to see '1' in formula bar as well. Is there any way to show such conversion in formula bar? If there any, please suggest me. Thank you.

[@chandoo_]

Thanks Suraj... As far as I know, this is not possible. Why not hide the formula bar instead? You can do it from the "View ribbon"

[@surajtharali1273]

@@chandoo_ Thank you Chandoo. I will hide the formula bar instead.👍

[@mutlunun]

Nice trick for rank avg

[@chandoo_]

You are welcome Mutlunun...

[@satheenkumar5317]

Hi how we can find top sales figure multiple department in each articles (dept /subdept/articles)

[@agboolaisaiaholaide5267]

please how can i extract a set of given data from a group data, all having unique id number?

[@NAVEENSHARMA-ss5vy]

Great

[@chandoo_]

Thank you :)

[@joycenaicker6251]

Thank you sir.

[@chandoo_]

Most welcome

[@syednabeelali6350]

Power BI kaha say milay ga

[@chandoo_]

Download it from powerbi website.. search it up.

[@sharmamunish104]

Sir kindly reply my query regarding move cammand of cmd.

[@hemachandral5043]

I need excel training

[@JustMe-sh8nd]

I really do not want to meet Gunar 💀

[@chandoo_]

🤣

[@FredrikDahlberg]

Conditional formatting.. the Devil’s tool….

[@CNYCNY1]

Sorry your formatting is really not pleasant. Won't work for business setting

[@chandoo_]

Feel free to format in whatever way works for you... There is no "RIGHT" way to do these things.

[@artofsalsa5268]

Another formula for top 3: =COUNTIF($B$4:$B$13,">" & $D4) < 3

[@chandoo_]

Goodone.. I think the first ref. should be $D$4:$D$13...

[@solinsaadi1886]

You're the best one in explaining Excel so far, Thanks a million!