Highlight Rows Based on Cell Value in Excel

In this tutorial, I will show you how to highlight rows based on a cell value using conditional formatting using different criteria.

This can easily be done using conditional formatting in Excel.

I cover the following examples in this video
-- Highlight rows based on the text value
-- Hight rows based on number value or date value
-- Highlight rows that have blank cells in it
-- Highlight rows based on multiple conditions

The technique here uses conditional formatting formula that checks each cell and applies the format if the result is TRUE and does not apply the format if the result is FALSE



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[KSnarky]

I RARELY comment on youtube content. Your presentation was concise, complete, informative and, most importantly, gave me exactly the answer I needed. Keep up the good work.

[bevhales]

I've watched a number of videos to find out this information, while it worked on the screen for the presenter, there was something missing, so I didn't get their results - then I found your video. It worked first time and gives me exactly what I was looking for. Now I can move my workload forward and hopefully you'll also have answers to other questions I come across. Thanks for your organised, logical and clear explanations. I don't know your name but I'm extremely grateful for your help, thank you. 😊

[menachemspielman]

Thank you! This is THE ONLY video that I've found after looking into this for like an hour that actually gave me what I needed, and even better, in an easy to understand way!

[paavosederholm]

This was great, and well explained! Only made it to 3:09 and already found what I needed :)

[BearBearCammy]

Oh Gosh! My 6 months headache has been solved! Thank you so much for your easy tutorial! Appreciate that!

[dbharadwa]

Been looking for someone to explain this properly and this man has done within the first few minutes of his video without any filler. So good I am gonna subscribe.

[davidwill]

Thank you from Tokyo. Your explanation solved all my problems!

[House]

Nice video ... it helped me figure out I was using to broad of a range on my formula. I'm getting the results I need with your very simple formula. Thank you for making something complex, easy to understand.

[tesshensch]

I am impressed by all your presentations. You jump right into the subject matter and give more time for detailed and concise explanations, making it easy for me to follow along. I have learned a lot from your videos (from the simple to the complex power queries) and always recommend your tutorials to people who use or trying to learn Excel. Thank you for sharing your knowledge and expertise. Looking forward to more tutorials!

[NigelStock-coach]

Excellent tutorial. Concise, very informative and just the right tempo.

[SPmorality]

you saved me a couple of days of work! You're a legend, sir

[willow]

Thank you so much for this info. You are very detailed and made very easier. Keep up the great work and thank you once again!

[janetgannon]

Hi Sumit. Thank you so very much for your video. I was able to pause and try it as you clearly explained and did it, and it has provided me with the exact solution that I have been looking for for ages. Looking forward to hearing more of your tips and tricks.

[contemporarytrend]

I am happy in this video that the problem I get is solved in a second! Thank you.

[thedylanshow]

Brilliant! I found the DATE tip the best one since I was trying to have my team's completed cell that had a date in it gray out that row. I just made the date a long time ago! Thank you!

[willierants]

Nicely done! I was going to write a long comment, but I'm not the first to comment on how well presented this was. So DITTO.

[ThomasPowersrockslide]

That was very helpful, just what I needed, and I was able to figure out how to do this in Google Sheets from here. I've been trying to figure this one out for a while, thanks very much.

[nickkapatais]

Excellent, concise and to the the point. Thank you.

[Shahbaz]

VERY GOOD AND TO THE POINT VIDEO. GOD BLESS YOU. KEEP UP THE GREAT WORK

[MarthaBHamilton]

Wow..this was great!! thank you! You were so good at explaining what you were doing and how to do it! and gave great "similar" but different examples!! You just made my life so much easier! Thank you - can't wait to try the new options you showed!