Excel Conditional Formatting with Formula | Highlight Rows based on a cell value
ฝัง
- เผยแพร่เมื่อ 29 มิ.ย. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn the art of Conditional Formatting in Excel using formulas! This tutorial shows you how to dynamically format cells and rows based on other cell values, perfect for enhancing your Excel skills.
⬇️ DOWNLOAD the workbook here 👉 pages.xelplus.com/conditional...
✨ What You'll Learn:
▪️ Basic concept of Conditional Formatting with formulas
▪️ Highlighting cells based on the value of another cell
▪️ Use conditional formatting to highlight entire rows
▪️ Troubleshooting tips for Conditional Formatting
Conditional Formatting in Excel is a great way to improve the readability of reports. You can focus the reader's eye on the important points and create an interactive element to your Excel data.
For example, you can use conditional formatting to highlight values that are greater, equal, or less than the value in another cell.
I'll also show you how you can properly use Excel conditional formatting with a formula. It can be tricky to get it right. If used incorrectly your conditional formatting will not work. To make sure you can successfully use formulas in Excel conditional formatting, I will share an Excel trick you can use to get it right every time.
00:00 Excel Conditional Formatting with Formula - the logic
03:12 Excel Trick for Conditional Formatting with Formula
04:42 Conditional Formatting based on another cell
05:35 Conditional Formatting Highlight Entire Rows
07:45 How to Copy a Range With Conditional Formatting in Excel
Playlist dedicated to advanced Excel tips & tricks: • Excel Advanced Formula...
_______________________________________________________
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/conditional-format-rows
Your videos have genuinely helped me demystify Excel! You have been that tutor that I was always looking for!
Genuinely useful and amazing videos! Please keep doing this.
Even your shorts have been extremely useful.
Thank you, Leila, for explaining everything so simple and in easy to understand way! Also, your voice is so pleasant, you are not in a hurry, and I can understand everything without the need to give a pause in order to assimilate. You are my favorite excel trainer :) Thank you and keep the same way!
Just wanted to thank you, your tutorials have been my favorite because you explain things so usefully! ❤️
I wish I knew that when I was learning the basics of Excel, trying to find the correct way to apply this Conditional Format! Thanks, Leila!!
Thank you Leila, I love the simplicity.
This is great, thank you Leila! I can binge watch your channel for hours, I learn so much!
Highly informative Leila! I was not aware of conditional formatting and its great uses here. I'm glad I subscribed; even though I am a beginner- your tips motivate me to learn more in excel.
I always struggled with these and this video made it so much easier to grasp. The trick to copy the formula and drag it across cells to see how it performed was perfect. Thank you.
thank you for your video makes my work easier and more fun to read, greetings from us in Dili, Timor-Leste, keep up the good work
Leila, you are a true Goddess of Excel. Same as for others, you demystified the conditional formatting for me today. Thank you.
Hi Leila. Great explanation! You make it very clear and understandable. Great bonus copy/paste formatting tips too. Thanks for sharing :)) Thumbs up!!
The keyboard short cut key for conditional formatting is (well it's not that short cut as such) ALT+H, L then N for conditional formatting new rule, with keyboard select last option "use formula to determine" and then ALT+O for formula bar activity. Using this will make you look like a Pro (hahaha) Thanks for sharing Leila :)
A phenomenal piece of work. Thank you.
Thank you so much. I was having trouble getting my formatting to apply to the other rows. This was the 4th video I watched and the only one that covered the removal of the $.
Thank you for creating and posting these tutorials. Your knowledge has helped me several times over, and your teaching method is clear and very precise. Thanks again!!!
Thankyou so much leila your courses never cease to amaze me, so calm and insightful at the same time
@Leila Gharani, you make the most awesome tutorials of any genre. Short effective and beautifully presented. Thanks a lot.
You are my go to for anything Excel. Amazing tutorial. Thank you! This helped my situation.
Really helped me. I require this kind of formatting in my workplace. This was super helpful. Thanks a ton !!!
Leila, your videos are very easy to understand. Thankyou!
Many thanks Leila! As always very useful.
Got to learn something new today. Thanks Leila.
I've written excel macros for over 20 years and never knew the tips I learned from this video. Personally, a game changer.
Your video's a life save. Thank you so much. This is such a little bug, but a real big headache. Was literally trying to figure this out for over half n hour.
This is super helpful. Appreciate this tutorial on conditional formatting :)
Glad you enjoyed it :)
Awesome, I was looking for this formula. Thanks
I missed your videos for last 2 weeks due to some work occupancy, but going to watch them soon! And this one of course is best as usual! Your appropriate examples with just enough explanation makes every task so simple to perform! Keep it up! 😊👍
Welcome back! Thank you Vijay 😊
Thank you. Your video reminded me how to fix some cells with broken conditional formatting formulas. All better.
Leila you are so good, you are amazing. nobody explains excel better than you, thank you so much ive learnt bundles
i watch your videos for fun, you have taught me so much!!!
I am not only fascinated about how you have explained this lesson, but I am also impressed about your video editting skills. You are awesome.
She is unbelievable!!! The is the best example to show how the explanation should be made on a particular topic.
Best tutor for excel Thank you Leila
This Tutorial is super Helpful. Thanks a lot Leila
Thank you, that it starts from the first cell in the selection was an important lesson for me.
This has always been difficult for me to do. Nice clean solution. Thanks. Great video!
Thanks, this worked for me - and really lovely tips
This was very helpful! Thanks!
This just saved me such a headache at work. EXACTLY the problem I was having. Thank you!
Super helpful Leila!
Love what you do, always concise and helpful. I would love you to add another level to this. Copying the conditional formatting when the second set of data is on another worksheet. Currently, I have to copy numbers and formatting to the second sheet, then adjust manually the cell reference on the second sheet. Is there a trick you could show about managing conditional formats across multiple sheets?
Thank you so much ! it was so helpful !
This was a great help!!! I just could not figure this out. Thanks!!!!
Soo easy to follow thank you! 😊
I have been using this method for a long time. The way you explain this is to the point and very easy to understand. Congratulations.
i love Leyla. thanks for sharing knowledge.
Great video, and very helpful!
Thank you ! Very clear !
Great clarification of how to apply conditional formatting. Thanks, Leila.
Glad you enjoyed it, Anthony!
Your videos have saved me many times. This one included. I am grateful that you are out there making your content.
I appreciate that, Charles!
Thank Leila. This was very helpful.
this was very helpful and informative. thanks.
Love it! Thank you so much!!!!
With all of the knowledge you have generously shared in so many videos I was able to create drop down lists and date fields in a Word document and then copy them into an Outlook email and save it as a Template. I now have a very reusable form when creating assignments. I couldn’t find these objects within Outlook, but copy/paste works. I bet you would do it 100x smarter though.
nice explanation with lots of good tips
Oh dear Leila my teacher ... This is exactly what I am currently looking for !!
Thanks a bunch !!
Talk about quality content. Thank you!
i got the benifit of watching this video as i was needing to colour some cells automatically. Thank you so much
Very useful tip. Thanks Leila. Cheers from Loveland, Ohio. (city near Cincinnati)
I always struggling with condition formatting, great help, thanks
Keep up the great work! So helpful, and easy to follow. Thank you so much for your hard work!
Thank you! Will do!
Very grateful for the videos
Thanks Laila, it worked.😊
What a brilliant video. Thanks.
Thanks, Leila for another great video. One quick correction. It's minor, but screw things up if that's the problem. Rule 2 (at 1:54) is often correct, but not always. The correct rule is that the format is always from the point of view of the cell which has the focus. In the example given (and most times this is true) it happens to be the first cell of the selection (cell B6 as noted just below the word "Clipboard" in the home ribbon). But depending on how you select your range, it could be the last cell or some other cell.
nobody explained the logics behind it but you did thank you.
Thank you very much for your informative tutorial.😊
Thank you so much. This was very easy to follow and solved my problem.
i loves loves lovess your content !
Thank you Leila for the information🙂
Thanks so much for this, I have been puzzling over this for days, should have come here first! So helpful!
You're very welcome!
Thank you Leila!
Very clearly explained. Followed the instructions and got it done in one try. 🙏🙏🙏
Thank you so much My honorable teacher.
Thank you very much Leila. I must've spent 2 days (off and on) trying to get conditional formatting to work. That is, until I saw yours with all the little nuances that were causing me so much grief. Again, thank you
Glad it was helpful.
Your videos are the best! Thank you :=)
Thank you, Leila. I always enjoy your videos. I was surprised by one of your older videos showing Bryon Smedley. I worked at the same company with Bryon years ago. He was a company software trainer. I always enjoyed his classes, as well.
Oh wow! Bryon is the best.
very cool you gave respect when its due to mike girvin . nice video
Thank you so much!! 👍🏻 👍🏻 👍🏻
Thank you very much ❤
Always love Leila's tutes 👍🏻
Thank you!
The row highlight trick was show stopper. Thanks for the tip.
My pleasure.
Fantastic explanation! 👍👍👍
very helpful for highlighting and visualizing the importance of some numbers in bigger sets of numbers 👍 Thanks !
My pleasure!
Very helpful, thanks
You probably just saved me my job with this video. Thanks
Glad it was helpful, Michael.
Best tutorial. I was stoke with my assignment and looking for a clear explanation for the conditional formating using formula and you are the one who explained it very clearly. May ALLAH bless you.
Just Excellent! Thank you Leila and may God bless you
Our pleasure!
Very clean and simple your learning method. I have learn very well.
Again it took me months not to say years of practicing to know all these tricks and you compiled it a short 10 mn video, great job as ever thank you very much Leila...
Great to hear!
Very useful trick... Simple but very useful.... Thank you Leila...🤗👌
Amazing as usual thank you
Thanks for explaining a difficult concept in a step by step approach. Great explanations.
Glad you liked it
Hello ma'am
I ve been watching some of your videos for a long. At first it was hard to me to understand, gradually I am understandable to that. Your ideas are advanced at the same time works for me . Now I use the way you say. Thank you so much for creating stuff like that.
I was looking for one solutionf googling the resolution, but after one and a half hour, I found your video and helped me in 5 minutes.... thank you!
Super helpful thank you
love your work
Leila, pretty useful, as always. Thank you
My pleasure!
I was really confused before but you have cleared em
I have always found Conditional FormTing via formulas to be challenging. This is a great explanation. Nice shout out to Mike Girvin and ExcelIsFun. You both deserve more credit than I can offer with a "Like" and a comment. Keep up the great work, it is appreciated.
Like and a comment is all the credit I need. Thank you for watching!