Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting

In this video, you'll learn how to format cells in Excel based on the value of another cell. This is a great way to quickly and easily create dynamic spreadsheets.

When you want to format a cell based on the value of a different cell, for example to format a report row based on a single column’s value, you can use the conditional formatting feature to create a formatting formula. This video explores the details of formatting a cell or range based on the value in another cell.

[bigchill]

You explained this so well, thank you for taking time to explain vs. simply sharing the formula.

[jeffzweygardt]

Thanks for explaining this so thoroughly, yet slow enough to make sense. I can see myself watching a LOT of your videos in the near future!

[hautecommercialrealestate]

The best video on YouTube explaining the syntax behind appropriate conditional formatting, thanks for making this!

[camillorighini]

Although I use advanced sheets for years, the way you explained Cond. Form. makes possible to understand the concept behind the logical thinking, like a programmer. After that I made some tests on a huge sheet and I could notice a new level of control of the conditional formatting. You made simple something no one could explain so clearly before. Congratulations!

[leticianava-mcmenamin]

I had been struggling to understand this topic. I looked everywhere for a solution that told me what I needed to know and didn't confuse me more than I was at the start: Your video ticked both boxes, so Thank you... Your explanation was simple and to the point, and the fact that you emphasized the importance of the active cell made everything even clearer.

[jen_revenant]

Thank you for this video! I've been struggling with conditional formatting and now I know what I was doing wrong!

[dandugan]

Thanks! I couldn't figure out how to do this myself. The confusing part was which cell I need to reference for relative references. You explained it perfectly!

[jbeesley]

Really well explained and so simple - thank you

[gunneraflleje]

thank you for your explanation, i’m currently taking a college excel class. and the book just gives us formulas with out truly explaining how to do it. this helped immensely in my application of this

[JyrgenStraus]

Excellent!! I just try to find answer for this for hours!!! Greetings from Finland.

[jayp]

Thankyou so Much for this! Broken down perfectly! I love to know the reasons why I'm doing something not just being told what to do! I need the reason so this is perfect Thankyou!

[DarkFenix]

Thank you very much for this video and information! Exactly what I was looking for in working on my own projects. Well put together video and very informative.

[nefisikara]

That was Amazing! Thank you for perfectly clear explanation!

[shamans]

The example formula used for 2 conditions was helpful for me. I had no idea what was wrong but the required formula was simple and didn't need IF or true/false components.

[JCBluenote]

This was excellent. Very easy to adjust for using Google Sheets for my home use as well!

[olgarohner]

Thank you so much! It solved the problem I was having at work. I used to spend lots of time highlighting rows. All of your videos are super helpful.<3

[fokhrulislam]

That explanation technique was just WOW!

[Kakkunuri]

Spot on - Very good explanation of conditional formatting I have ever seen. Most of the problems solved

[hmarie]

THANK YOU!! Excellent explanation and pace of video

[ahmedbawazir]

Superb Explanation. Also I like the key explanation about locking the cells when we need to highlight complete row. Thank you So Much 💖