Skip to main content
AmigoFish

Most Excel Users Don't Know Conditional Formatting Can Do This

From MyOnlineTrainingHub Ā· Ā· 17 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Learn Excel conditional formatting with formulas to highlight rows based on a cell value. šŸ‘©ā€šŸ« Learn more about my Advanced Excel Formulas course: https://bit.ly/cfformulas26course ā¬‡ļø Download the example file here and follow along: https://bit.ly/cfformulas26file

Most Excel users never go beyond the built-in conditional formatting rules: a colour scale here, a "greater than" rule there. But the moment you start using formulas, everything changes.

Formula-based conditional formatting lets you highlight entire rows, flag missing data, catch errors, track deadlines; all automatically, in real time.

In this video, I'll show you the rules that will save you from manually scanning your spreadsheet trying to spot problems. Real-world examples, practical scenarios, stuff you'll actually use.

LEARN MORE ===========

šŸ“° EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

šŸŽÆ FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

šŸ’¬ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

ā² TIMESTAMPS ============== 0:00 What most Excel users are missing 0:36 Format entire rows based on one cell 2:23 Compare two columns with conditional formatting 4:38 Flag rows with missing data 7:15 Make Excel search and highlight keywords 9:17 Create date-based alerts that update themselves daily 11:39 Detect duplicates Excel's built-in tool misses 14:42 Banded rows that survive filters 17:14 Excel functions every professional should know

#Excel #ConditionalFormattingInExcel #ExcelTutorial

Back to MyOnlineTrainingHub Ā· Report a problem