Conditional Formatting

Purchase this course to access all lessons and start learning.

Introduction
Video Time
Save Video 1. What is conditional formatting? Watched 2:33
Working with conditional formatting rules
Video Time
Save Video 2. How to create a conditional formatting rule Watched 2:27
Save Video 3. How to revise a conditional formatting rule Watched 2:56
Save Video 4. How to add additional conditional formatting rules Watched 2:58
Save Video 5. How to delete conditional formatting rules Watched 2:20
Built-in Conditional formats
Video Time
Save Video 6. How to highlight top and bottom values Watched 2:45
Save Video 7. How to highlight above and below average values Watched 2:43
Save Video 8. How to use data bars with conditional formatting Watched 3:10
Save Video 9. How to use color scales with conditional formatting Watched 2:58
Save Video 10. How to use Icon sets with conditional formatting Watched 2:56
Save Video 11. How to highlight text values with conditional formatting Watched 2:08
Save Video 12. How to show duplicate values with conditional formatting Watched 1:59
Conditional formatting with formulas
Video Time
Save Video 13. How to apply conditional formatting with a formula Watched 2:41
Save Video 14. Conditional formatting based on a different cell Watched 2:24
Save Video 15. Conditional formatting with one variable input Watched 2:43
Save Video 16. Conditional formatting with two variable inputs Watched 2:59
Save Video 17. How to highlight rows with conditional formatting Watched 2:53
Save Video 18. How to highlight rows using multiple criteria Watched 3:18
Save Video 19. How to test conditional formatting with dummy formula Watched 3:28
Save Video 20. How to test a conditional formatting formula Watched 3:15
Practical application
Video Time
Save Video 21. How to add a conditional formatting key Watched 3:28
Save Video 22. How to check line length with conditional formatting Watched 3:06
Save Video 23. How to build a search box with conditional formatting Watched 3:34
Save Video 24. How to create zebra stripes with conditional formatting Watched 3:30
Save Video 25. How to calculate and highlight expiration dates Watched 3:54
Save Video 26. How to compare two lists and highlight differences Watched 2:28
Save Video 27. How to highlight exact match lookups Watched 4:05
Save Video 28. How to highlight approximate match lookups Watched 3:55
Save Video 29. Shade groups of rows with conditional formatting Watched 3:01