Master Conditional Formatting in Excel (The CORRECT Way)

[@KenjiExplains]

🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/mn9

[@PETERSSEBUFU-y4y]

Hello

[@PETERSSEBUFU-y4y]

I need your email

[@teymura3461]

Such amazing content. Very easy to understand and then apply accordingly. You are a great teacher.

[@KenjiExplains]

Thank you so much!

[@sujanshah2214]

Thank you for sharing Kenji.🎉

[@sarazafar849]

Hey Kenji, I love your videos and how simply you explain it all! Can you also make a video on mail merge? I'm an HR learning to make the most of Excel through your videos!

[@teamwinkler4526]

Excited to utilize these in next month's reporting package!

[@yeyramos1]

great info. Can we use conditional formatting to delete those highlighted rows?

[@RedsparInvesting]

Hello Kenjij. You explain everything so well but it all gets a bit overwhelming for me sometimes. I have one particular problem to solve : i want cells that are all dates in a vertical row to change color when a specific date is reached to change colour. Is there a formula for that pls

[@karthikkeyan3902]

Hello keinji, without going to power query, but using vstack itself we can combine all sheets but converting all sheets into separate tablesand naming each sheet table as Jan,Feb, & march, and in consolidated file using the formula =vstack(Jan,Feb,march), the combined data will come in consolidated sheet dynamically. It works for me

[@Machende100]

Can you perform conditional formatting on a Histogram the same way as you do with the data in your example?

[@miamited69]

Great explanation. What if I want to format based on values in a list regardless of which one matches?

[@adriendj1394]

Hello Kenji, thank you very much for your content. It is always interesting and helpful. But I was wondering if it was possible to apply conditions to gradient bars such as the cell is proportionally filled with green from 0% to 100% and then when it is above 100% the databar reaches the end of the cell in gradient red whatever is the % (be it 109% or 350%) ?

[@laf4891]

Thank you so much for this video. It was really helpful and clear. I didn't know about this tool.

[@godofredosaraiii9326]

I really love your videos. I learned I lot from it. I just would like to ask, is there a way in excel to hide rows that has a percentage that is higher a certain value? I already tried to Google or search it on KZbin but I am having a hard time to find the answer I need. Thank you for your help.

[@KenjiExplains]

Thank you! If you mean hiding certain rows if a condition is true (like a % that is higher than x value) I don't think that's possible. You can leave them blank, but not haven't heard of being able to hide rows entirely.

[@godofredosaraiii9326]

@@KenjiExplains I really appreciate your help bro. I will keep learning on videos.

[@Manuel44559]

Brilliant 👏 thank you so much for this

[@BorbzP]

is it possible to have two cells one with a starting date and another with ending date and in a seperate column there would only dates from starting to ending show up ?

[@ICCY22]

This helped me greatly !😃

[@RexxorDDG]

You are helping me alot in my business stats class lol

[@RaviniHasika]

Amazing work! I'm wondering which country you are from

[@rickstanley972]

what if I need more than one rule for the column. For example, if I want to know the top 5 revenues, but I also want the bottom 5 revenues?

[@camlex6310]

Wow great tips!!

[@luizniceas]

Excellent video, very useful. Thanks for sharing!

[@KenjiExplains]

Glad it was helpful!

[@ahmedmohammedabdullahi4011]

That's great teaching

[@craiggambetta694]

Can you help me, i am wanting to highlight in different colors when the percentage drops below 45% or when above 55% and a different color when within these ranges

[@Roseformyself]

Thank you. Every video is applicable.❤❤

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

[@bachle2384]

It's great! Thank you!

[@Spratik1_2_6]

Great work 🎉

[@LetsLearnEnglish-tk9sw]

Can anyone plz reply me Is that all of conditional formatting?

[@jiilaanhani311]

thank you!

[@udunknow2172]

Thanks for the video

[@james-sk1si]

Great video

[@itumelengmotshabi6679]

Hi, Kenji. I wonder if this is a prolem. I have guest book spreadsheet which I report to my boss to now my problem is c4 is number of day and h5 is number of guest, I5 is number of people in conference room, n5 is how much I charge per person and O5 Grand total my formula is =IF(H5

[@tanveerabbas3271]

thks bro

[@SachinBele-o6z]

how to find value greater than 10 from MIN value in a row

[@ResumeEX]

When i copy and paste numbers from a different sheet to my conditional formatting template, it turns the pasted cells white. Any tips?

[@aasanbhasa1686]

Past as value

[@arvindpandey8793]

Nice

[@ahmadramin-nw4jx]

Great

[@willzinner8813]

Didn't know the dates feature at 6:32 thanka

[@KenjiExplains]

thanks!

[@ruslanazimov8616]

Awesome

[@KenjiExplains]

Thank you!

[@olukunleayobamipetrosagboo6164]

Kudos

[@KenjiExplains]

thanks!

[@deanroderick611]

Where are you getting 90% of users from?

[@syedtahirbukhari8377]

In dream

[@nilawagner]

Love your videos and tried to subscribe, but I'm not receiving any emails from you FYI

[@KenjiExplains]

Hey you should have received the excel download in your browser/desktop downloads folder

[@waqasmaqbool3356]

thnku

[@_JP_7]

How to Autofill row color if cell is blank ?

[@andhikajansenreforwan]

4:00 I tried to not set a goal for highlight entire row, and i just type a number after a =$H3 value, so the formula will be like this =$H3>20000 (the goal number) and it's also worked

[@SCALP.___]

Am loving everything, kudos @kenjiExplains

[@KenjiExplains]

Thank you for your nice comment!