Excel Conditional Formatting with Formula | Highlight Rows based on a cell value

preview_player
Показать описание

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.

✨ 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

_______________________________________________________

🚩Let’s connect on social:

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
Рекомендации по теме
Комментарии
Автор

Leila, you are a true Goddess of Excel. Same as for others, you demystified the conditional formatting for me today. Thank you.

MrNoBSgiven
Автор

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.

dkt
Автор

❤I watch your videos every time I get stuck in a formula and cant thank you enough. You always put the exact solution in to what I am missing. This one you had me remove the “$” from the lookup reference and POOF! Fixed. Thank you so much!!! Love your videos so much.

richardreid
Автор

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

egasbritesdasilva
Автор

Thank you, thank you, thank you!!! I had watched three other tutorials before this one, and yours was the first one that I could follow and it worked.

andycummings
Автор

I’ll never get the 2 hours I spent last week trying to get this to work BUT you have solved the headache that I got from that and I’ll NEVER get this particular headache again. As I’ve stated before YOU ARE THE

ldmlhome
Автор

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 :)

sachinrv
Автор

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

mpart_woodlathe-stuff
Автор

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

harishn
Автор

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

miguelplg
Автор

A phenomenal piece of work. Thank you.

TheSlarge
Автор

Your videos have saved me many times. This one included. I am grateful that you are out there making your content.

charlescaison
Автор

This is a great tutorial, thank you! I learned a LOT.

RameeJordan
Автор

This is super helpful. Appreciate this tutorial on conditional formatting :)

TylerStanczak
Автор

I've written excel macros for over 20 years and never knew the tips I learned from this video. Personally, a game changer.

andywrentmore
Автор

This is great, thank you Leila! I can binge watch your channel for hours, I learn so much!

brazilbeyondtheheadlines
Автор

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 $.

ogrammer
Автор

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.

new_moon_
Автор

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!

meshell
Автор

Just wanted to thank you, your tutorials have been my favorite because you explain things so usefully! ❤️

prin