Excel Formulas & Functions Part 8: Formula-Based Formatting

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Videos (25m)
    • Introduction to Formula-Based Formatting

      1:30
    • Creating, Editing & Managing Formula-Based Rules

      4:39
    • Highlighting Every Other Row Using the MOD Function

      3:50
    • Formatting Cells Based on the Value of Another Cell

      3:29
    • Formatting Cells Using Statistical Functions

      5:28
    • Formatting Cells Using Text Functions & Logical operators

      5:08
    • HOMEWORK: Formula-Based Formatting

      0:34

About This Class

This course is part 8 of a 9-part series on Excel Formulas & Functions: from basic to advanced.

Formula-based formatting is all about using formulas to create custom, dynamic formatting rules in Excel. This allows you to go beyond the standard, "out of the box" formatting tools and templates, and apply custom styles based on underlying functions. This section introduces several case studies, including highlighting rows using the MOD function, formatting based on the value of other cells, and using text functions and logical operators to trigger custom effects.

About the Excel Formulas & Functions Series:

In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel.

You'll learn how to write complex, powerful functions from scratch, allowing you to:

  • Build dynamic tools & dashboards to filter, display and analyze your data
  • Join datasets from multiple sources in seconds with LOOKUP, INDEX & MATCH functions
  • Pull real-time data from APIs directly into Excel using WEBSERVICE & FILTERXML
  • Manipulate dates, times, text, and arrays with ease
  • Automate tedious and time-consuming analytics tasks (no VBA required!)
  • And much more

If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!

4

Students

--

Projects

Chris Dutton

Founder, Excel Maven

Chris Dutton is a Certified Microsoft Expert and Analytics Consultant with more than a decade of experience in the B.I and data science fields. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to clients and students across 130+ countries.

See full profile