Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples

Download workbook: Start file: https://people.highline.edu/mgirvin/A...
Finished File: https://people.highline.edu/mgirvin/A...

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video:
1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. (00:00:44 min)
2. Highlight Cell Rules: Type in textbox: Greater than 1000 (00:02:05 min)
3. Highlight Cell Rules: Type in textbox: Contains "Fun" (00:03:00 min)
4. Highlight Cell Rules: Link textbox to cell: Greater than 1000 (00:03:36 min)
5. Highlight Cell Rules: Link textbox to cell: Contains "Fun" (00:04:13 min)
6. Top Bottom Rules: Top 3 (00:04:46 min)
7. Top Bottom Rules: Above Average (00:05:13 min)
8. Data Bar on top of numbers (00:05:29 min)
9. Data bars in cell next to numbers. Also RANDBETWEEN Conditional Formatting. (00:05:53 min)
10. Manage Rules dialog Box (00:06:15 min)
11. Manage Rule dialog box keyboard: Alt, O, D (00:10:31 min)
12. Color scales = Ranks number by color. (00:07:23 min)
13. Fun with CF, RAND, and Bubble Chart (00:08:12 min)
14. Icon: Arrow Icons on top of numbers (00:09:42 min)
15. Icon: Arrow Icons next to numbers (00:10:12 min)
16. Logical Formulas. Get Formatting = TRUE or Any Non-Zero Number. NOT Get Formatting = FALSE or Zero or Error. (00:11:14 min)
17. Format number less than zero: 3 methods (00:12:35 min)
18. Format Actual when Actual Exceeds Budgeted: 2 methods (00:17:27 min)
19. Keyboard for New Format Rule dialog box: Alt, O, D, Alt + N or Alt, H, L, N (00:19:29 min)
20. Keyboard to open CF Rule Manager to edit or delete a rule: Alt, O, D, D, Enter (00:39:25 min or 01:05:51 min)
21. Clear Content and CF still remains (00:20:02 min)
22. Format cell based on a different cell's value: Format Net Sales based on Date (00:20:47 min)
23. Sort and CF will adjust (00:21:53 min)
24. Format cell based on a different cell's value: Format Net Sales based on Invoice number (00:22:09 min)
25. Format whole row based on date (00:22:36 min)
26. Format whole row based on Invoice number (00:26:13 min)
27. Format Row when Actual Exceeds Budgeted (00:27:32 min)
28. Format whole column (00:29:21 min)
29. Format cell based on OR criteria: OR function. (00:30:51 min)
30. Format cell based on OR criteria: MATCH function (Errors are ignored, Any non-zero number = TRUE). (00:33:10 min)
31. Format whole row based on OR Criteria use MATCH (Errors are ignored, Any non-zero number = TRUE). (00:35:19 min)
32. Format cell based on AND Criteria: Between Upper and Lower Date: AND Function. (00:37:55 min)
33. Format whole row based on between Date Criteria (00:40:01 min)
34. Format whole row based on AND Criteria from different columns (00:41:16 min)
35. Format whole row based on OR and AND Criteria (00:43:09 min)
36. Format entire row when sales are above average (00:45:49 min)
37. Format every other row with MOD function (1 = TRUE, 0 = FALSE) (00:47:18 min)
Copy Conditional Formatting: (00:50:18)
38. Format Row In Checkbook when Reconciled (00:50:54 min)
39. Format Entire Row for the 3 Biggest Values (00:52:24 min)
40. Format lowest Price in Row (00:53:50 min)
41. Format intersecting cell (00:56:50 min)
42. Format row based on Approximate Match based on VLOOKUP (00:59:13 min)
43. Multiple Rules applied to each cell: Format row, column and intersection value (01:02:41 min)
44. Gantt Chart for Day Schedule Cell Chart (01:08:11 min)
45. Format Weekends and Holidays NOT WORKDAY.INTL NETWORKDAYS.INTL function (01:13:31 min)
46. Format Duplicates Built-in Method or Formula Method: 2 methods (01:18:00 min)
47. Format items in List 2 that are NOT in List 1 (01:20:18 min)
48. Format items that are in List 2 that are also in List 1 (Errors are ignored, Any non-zero number = TRUE). (01:21:40 min)
49. Format stocks with a loss (01:22:29 min)
50. Format cells that are not empty, using COUNTA (Any non-zero number = TRUE, Zero = FALSE) (01:23:07 min)
51. MAX For Seattle (Array Formulas work in Conditional Formatting dialog box) (01:24:35 min)