Excel - Advanced Conditional Formatting with sample Excel file - 3 examples

Conditional Formatting in Excel is a fantastic feature. Did you know you can write functions inside Conditional Formatting? Writing functions inside Conditional Formatting is a great way to find the Average, Max, Min, and select entire rows that meet your criteria. I'll use Conditional Formatting with three examples in this short video. The file is below if you want to download it.

Chapters:
0:00 Intro
0:25 Conditional Formatting - Equal To
2:05 Conditional Formatting - Average function
4:20 Conditional Formatting - Max function

Excel file for Advanced Conditional Formatting

Excel Conditional Formatting - Getting started with five examples = Blog post

#excel #msexcel #microsoftexcel #chrismenard #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[surauar-raudhahkempadangse]

Thanks Chris. How to count automatically when the rows selected? Say, I use CF to highlight a numbers > or<. When rows selected, then one cell has count on it, I can see the total of highlighted rows. Thanks.

[Angel-jvzv]

Thank you for sharing your knowledge with us, truly appreciate it!.
I'm also thankful for sharing the file with us, there are other channels that make you subscribe to newsletter and other stuff, but you just give it to us for free. Big thanks for that.