Conditional Formatting Basic to Advanced - 30 Examples

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Explore 30 advanced Excel conditional formatting techniques in this comprehensive tutorial video. Learn to highlight above-average sales, create top 5 lists, implement data bars and color scales, use icon sets, and apply complex formulas for row and column highlighting. Master Gantt chart creation, weekend and holiday highlighting, and data validation. Discover built-in duplicate highlighting features and custom formulas for comparing actual vs. budgeted values. Download the provided Excel start file to practice alongside the instructor and enhance your spreadsheet formatting skills.

Syllabus

1. Above Average for Sales minute mark
2. Below Average for Sales minute mark
3. Top 5 minute mark
4. Greater than 600 minute mark
6. Color Scale minute mark
7. Icon minute mark
8. Highlight Sales that are on 5/25/2011 minute mark
9. Highlight Entire Row for invoices sold on 5/25/2011 minute mark
10. Highlight Entire Row for invoices #10501 minute mark
11. Highlight entire row when sales are above average minute mark
12. Highlight every other row with MOD function minute mark
13. Highlight Row In Checkbook when Reconciled minute mark
14. Highlight Entire Row for the 3 Biggest Values minute mark
15. Highlight Entire Row for Sale Rep Moe AND Sales Greater Than500 AND Criteria AND function minute mark
16. Highlight Entire Row for Sales Rep Moe or Joe OR Criteria OR function minute mark
17. Highlight Entire Row that contains a date between two dates minute mark
18. Highlight Entire Row based on both AND Criteria and OR Criteria AND and OR function together minute mark
19. Highlight entire row based on Approximate Value VLOOKUP function minute mark
20. Highlight entire column based on Exact Match minute mark
21. Highlight Intersecting Value based on both an approximate match for row header and Exact Match for column header minute mark
22. Highlight row based on two row headers minute mark
23. Highlight entire column based on Exact Match minute mark
24. Highlight Intersecting Value based on row header and column header Exact Match minute mark
25. Gantt Chart for Days minute mark
26. Highlight Weekends and Holidays NOT WORKDAY.INTL NETWORKDAYS.INTL function minute mark
27. Data Validation Custom Formula for preventing Sunday and Holiday Dates to be entered in cell minute mark
28. Highlight Duplicates: Built In Feature minute mark
29. Highlight Duplicates Formula minute mark
30. Highlight Row when Actual Exceeds Budgeted minute mark