Completed
11. Highlight entire row when sales are above average 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
