Hacks #16-38
Section 16. Validate Data Based on a List on Another Worksheet
Section 17. Control Conditional Formatting with Checkboxes
Section 18. Identify Formulas with Conditional Formatting
Section 19. Count or Sum Cells That Meet Conditional Formatting Criteria
Section 20. Highlight Every Other Row or Column
Section 21. Create 3D Effects in Tables or Cells
Section 22. Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Section 23. Support Multiple Lists in a ComboBox
Section 24. Create Validation Lists That Change Based on a Selection from Another List
Section 25. Force Data Validation to Reference a List on Another Worksheet
Section 26. Use Replace... to Remove Unwanted Characters
Section 27. Convert Text Numbers to Real Numbers
Section 28. Customize Cell Comments
Section 29. Sort by More Than Three Columns
Section 30. Random Sorting
Section 31. Manipulate Data with the Advanced Filter
Section 32. Create Custom Number Formats
Section 33. Add More Levels of Undo to Excel for Windows
Section 34. Create Custom Lists
Section 35. Boldface Excel Subtotals
Section 36. Convert Excel Formulas and Functions to Values
Section 37. Automatically Add Data to a Validation List
Section 38. Hack Excel's Date and Time Features