Chapter 2. Hacking Excel's Built-in Features 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 |