Master Conditional Formatting in Excel (The CORRECT Way)

Рет қаралды 101,011

Kenji Explains

Күн бұрын

Пікірлер: 59

@KenjiExplains 10 ай бұрын

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

@PETERSSEBUFU-y4y 10 ай бұрын

Hello

@PETERSSEBUFU-y4y 10 ай бұрын

I need your email

@teymura3461 10 ай бұрын

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

@KenjiExplains 10 ай бұрын

Thank you so much!

@sarazafar849 7 ай бұрын

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!

@sujanshah2214 10 ай бұрын

Thank you for sharing Kenji.🎉

@laf4891 5 ай бұрын

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

@teamwinkler4526 9 ай бұрын

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

@karthikkeyan3902 3 ай бұрын

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

@RexxorDDG 10 ай бұрын

You are helping me alot in my business stats class lol

@RedsparInvesting 10 ай бұрын

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

@miamited69 8 ай бұрын

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

@Manuel44559 10 ай бұрын

Brilliant 👏 thank you so much for this

@yeyramos1 10 ай бұрын

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

@adriendj1394 10 ай бұрын

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%) ?

@ICCY22 5 ай бұрын

This helped me greatly !😃

@godofredosaraiii9326 10 ай бұрын

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 10 ай бұрын

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 10 ай бұрын

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

@luizniceas 9 ай бұрын

Excellent video, very useful. Thanks for sharing!

@KenjiExplains 9 ай бұрын

Glad it was helpful!

@camlex6310 10 ай бұрын

Wow great tips!!

@Roseformyself 9 ай бұрын

Thank you. Every video is applicable.❤❤

@Machende100 2 ай бұрын

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

@BorbzP 4 ай бұрын

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 ?

@Spratik1_2_6 10 ай бұрын

Great work 🎉

@RaviniHasika 9 ай бұрын

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

@ahmedmohammedabdullahi4011 10 ай бұрын

That's great teaching

@bachle2384 8 ай бұрын

It's great! Thank you!

@craiggambetta694 5 ай бұрын

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

@lalitkumarpandey5911 10 ай бұрын

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.

@james-sk1si 10 ай бұрын

Great video

@rickstanley972 2 ай бұрын

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?

@jiilaanhani311 4 ай бұрын

thank you!

@udunknow2172 9 ай бұрын

Thanks for the video

@andhikajansenreforwan 3 ай бұрын

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

@LetsLearnEnglish-tk9sw 3 ай бұрын

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

@itumelengmotshabi6679 9 ай бұрын

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