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

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

Amazing

you are really amazing and down to earth and humble guy

Very useful ❤

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

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

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?

Thanks for the data bar tip!
📊🙂

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

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?

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

Very helpful. Thanks

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 !!

could uoyplease make a video on latitude and longitude in excel

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

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.

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.

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

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

Lovely Tips!

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

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

Thanks for video.

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

Conditional formatting.. the Devil’s tool….

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

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

GOOD STUFF!

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

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

🤘Rock On! Thanks for a great lesson!

Nice sir can u please also make videos on SAP

This was great. Super helpful to show in incremental steps

I need excel training

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

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

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

Great CF tips! Thanks Chandoo. Thumbs up!!

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

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

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

Gunar Cockshoot 😂😂

Super! Thank you for sharing!

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

Loaded with value.

Thanks for your kind help.
Regards.

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

Power BI kaha say milay ga

Wonderful as Always. A new Subscriber

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.