Great Videos on Conditional Formatting in Excel 2010

http://www.youtube.com/watch?v=LOaezdoyJDE&feature=related
I found a great series on Conditional Formatting on Youtube you should check them out.  Here is a list of the subjects covered:

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