Use Excel Conditional Formatting to Enhance Data Analysis | John Smith | Skillshare

# Use Excel Conditional Formatting to Enhance Data Analysis

#### John Smith, Business Owner

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

3:49
• 2. More Examples of Using Conditional Formatting

2:53
• 3. Excel Knowledge Prerequisites Before Taking This Course

1:01
• 4. How to Remove Conditional Formatting

1:59
• 5. Greater Than

1:50
• 6. Less Than

1:36
• 7. Between

1:10
• 8. Equal To

1:46
• 9. Text That Contains

1:32
• 10. A Date Occurring

2:49
• 11. Duplicate Values/Unique Values

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

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

1:24
• 14. Above and Below Average Conditional Formatting

1:27
• 15. Gradient and Solid Data Bar Fills

3:41
• 16. Introduction and Explanation of Icon Sets

1:26
• 17. Directional Icon Sets

1:03
• 18. Shapes and Indicator Icon Sets

1:35
• 19. Ratings Icon Sets

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

1:40
• 21. Using Conditional Formatting In Filters

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

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

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

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

2:45
• 26. Highlight Cells Containing Time Information Using Formulas

4:05
• 27. Creating Custom Icon Set Ranges

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

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

2:15
• 30. Comparing Values In Two Columns Using Formulas

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

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

3:05
• 33. Finding Duplicates Using Formulas in Conditional Formatting

1:06
• 34. Finding Duplicates Using Criteria From Two Columns

1:30
• 35. Using Conditional Formatting to Find Discrepancies

1:43