Main Profile

At A Glance

Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 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)
Length: 01:09:30

Contact

Questions about Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)

Want more info about Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question