Play all

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

Description:

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.

Conditional Formatting Basic to Advanced - 30 Examples

ExcelIsFun

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization #Computer Science #Information Technology #Data Management #Data Validation #Project Management #Gantt Charts

0:00 / 0:00