Master Conditional Formatting in Excel (The CORRECT Way)
HTML-код
- Опубликовано: 19 июн 2024
- Conditional formatting tutorial in Excel from beginner to pro.
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/mn9
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this video you'll learn how to use conditional formatting in Excel from scratch. Conditional formatting is one of the most powerful features in Excel, yet 90% of Excel users don't know how to use it to its full capacity.
So in this video we'll cover all of the key aspects so you can learn how to use it correctly. This includes conditional formatting formulas, data bars, color scales, and much more. After this conditional formatting tutorial in Excel, you will be able to apply conditional formatting to any work setting.
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Conditional Formatting Basics
1:06 - Custom Rules and Formats
3:46 - Highlight Entire Row Using Formula
5:23 - Highlight the Top Values
6:27 - Conditional Formatting for Dates
7:18 - Percentage Icons
8:42 - Color Scales & Data Bars
9:34 - Bonus Feature
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/mn9
Hello
I need your email
Thank you for sharing Kenji.🎉
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!
It's great! Thank you!
Brilliant 👏 thank you so much for this
Thank you. Every video is applicable.❤❤
Wow great tips!!
Excited to utilize these in next month's reporting package!
Great work 🎉
Thanks for the video
That's great teaching
Amazing content Kenji. You're my go-to guy for any Excel questions that I have
Thank you! 🙏
Such amazing content. Very easy to understand and then apply accordingly. You are a great teacher.
Thank you so much!
Great video
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%) ?
Excellent video, very useful. Thanks for sharing!
Glad it was helpful!
great info. Can we use conditional formatting to delete those highlighted rows?
Great explanation. What if I want to format based on values in a list regardless of which one matches?
You are helping me alot in my business stats class lol
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
Great
Amazing work! I'm wondering which country you are from
Nice
Awesome
Thank you!
Kudos
thanks!
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 RUclips but I am having a hard time to find the answer I need. Thank you for your help.
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.
@@KenjiExplains I really appreciate your help bro. I will keep learning on videos.
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.
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
When i copy and paste numbers from a different sheet to my conditional formatting template, it turns the pasted cells white. Any tips?
Past as value
Didn't know the dates feature at 6:32 thanka
thanks!
thnku
Subscribe!
Love your videos and tried to subscribe, but I'm not receiving any emails from you FYI
Hey you should have received the excel download in your browser/desktop downloads folder
Am loving everything, kudos @kenjiExplains
Thank you for your nice comment!