Use Excel Conditional Formatting to Enhance Data Analysis

John Smith, Business Owner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
35 Videos (1h 19m)
    • What Is Conditional Formatting?

      3:49
    • More Examples of Using Conditional Formatting

      2:53
    • Excel Knowledge Prerequisites Before Taking This Course

      1:01
    • How to Remove Conditional Formatting

      1:59
    • Greater Than

      1:50
    • Less Than

      1:36
    • Between

      1:10
    • Equal To

      1:46
    • Text That Contains

      1:32
    • A Date Occurring

      2:49
    • Duplicate Values/Unique Values

      2:53
    • Top and Bottom X Amount of Items Conditional Formatting

      1:14
    • Top and Bottom X% of Items Conditional Formatting

      1:24
    • Above and Below Average Conditional Formatting

      1:27
    • Gradient and Solid Data Bar Fills

      3:41
    • Introduction and Explanation of Icon Sets

      1:26
    • Directional Icon Sets

      1:03
    • Shapes and Indicator Icon Sets

      1:35
    • Ratings Icon Sets

      1:05
    • Conditional Formatting Based on a Specific Cell (Highly Recommended)

      1:40
    • Using Conditional Formatting In Filters

      1:59
    • Order of Conditional and How to Change It

      3:17
    • Copy and Paste Conditional Formatting in Different Sheets and Workbooks

      6:09
    • Introduction to Creating Your Own Custom Conditional Formatting Rules

      4:24
    • Before Creating Custom Formulas You Need to Know How to Lock Rows and Columns

      2:45
    • Highlight Cells Containing Time Information Using Formulas

      4:05
    • Creating Custom Icon Set Ranges

      2:01
    • Highlighting the Whole Row Based on a Column

      2:52
    • Dynamic Way of Selecting Whole Row Based on a Cell

      2:15
    • Comparing Values In Two Columns Using Formulas

      1:30
    • Comparing Two Different Lists For Matches or Mismatches

      2:44
    • Changing Colours of Alternating Rows Using Formulas in Conditional Formatting

      3:05
    • Finding Duplicates Using Formulas in Conditional Formatting

      1:06
    • Finding Duplicates Using Criteria From Two Columns

      1:30
    • Using Conditional Formatting to Find Discrepancies

      1:43