Excel Conditional Formatting Formulas - Format Like a Pro

★ Want to automate Excel? Check out our training academy ★

★ Get the example file ★
Sign up for our free Insiders program and get the example file:

★ About this video ★
In this video, we dive deep into Conditional Formatting Formulas in Excel, revealing how you can dynamically highlight data based on specific conditions.

Whether you want to format an entire row based on a single cell’s value, compare data across columns, or create visually engaging dashboards, this tutorial will show you exactly how to do it step by step.

No more manual highlighting—let Excel do the work for you!

By mastering these techniques, you'll save time, reduce errors, and make your spreadsheets more insightful.

If you're ready, let's get started.

0:00 Introduction
0:21 Conditional formatting formulas
3:37 Formatting a row
5:55 Avoid interim calculation
6:58 Potential issues
8:27 Wrap-up

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

[Lost]

the method of using true and false clicked every thing in my brain and now i fully understand how applying conditional formatting using formulas works! thanks, this deserve more views for sure!

[oncedidactic]

Having recently fought with the bad UI to trial and error this, I can say this is a perfect rundown and should be the go to reference for beginners. Nicely done

[kebincui]

Crystal clear and well explained, thanks Mark 👍👍

[IvanCortinas_ES]

Excellent treatment of the case, as always. Thank you, Mark.

[KarimMGS]

Excellent, clear video. Keep up the good work! 👏🏽

[ersingungor]

Always looking forward to watching something new from your channel

[chta]

Thanks Mark! I admit, I always struggle with the formulas to get them right. From now on, this hopefully will be no more problem ;-)

[waleedahmed-fh]

you just gave me an idea for making formats for an income statement!

[zdzislawkes]

Hi, I wonder when conditional formatting (if ever) will become dynamic like array formulas...

[AdamFahn]

Great video. At the end of the video, the order of fhe conditonal formatting is the wrong way in my head. You hadnt selected stop if true so doesnt that mean it will work through tnem from the top, or is it actually saying the top one has priority?

[khumabakground]

I just found your channel, and what came to mind is "Aha! New stuff I am about to go Pro" 😂😂😂

[gonzuic]

Hi Mark, thank you for this video.
When will we watch a video of Power Query?
See you.

[jeffstevens]

Hey Mark, nice primer on Conditional Formatting. My biggest wish for improvement on Conditional Formatting would be to allow for changes in font and font sizes. Any way we could get Microsoft to allow that?

[issakone]

Tres bien explique. Comlent vous Avez traduit la vidzo

[AndreaUK]

I faced this exact problem recently. I had to do everything manually, and it was so frustrating! I know there's a better way, but with limited time, it's hard to learn new things. Now, I'm taking my time to learn on my own. I wanted to format rows by supplier name so that each group of suppliers has a distinct color. The subtotal feature almost met my needs, but it wasn't quite right. Table design samples weren't helpful because they format alternating rows, and I had 10 rows for 'X' company, 7 rows for 'Y' company, and 30 rows for 'Z' company. I needed to format each supplier group separately. Can I use your formula to achieve this?

[mtab]

I like conditional formatting but the equations break when rows are deleted or added and cells are moved. Even when I use the dollar sign to fix the column it breaks