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