➔For a detailed discussion of conditional formatting, see “Using Conditional
Formatting to Identify Key Values,” p. 709.
Troubleshooting Formulas
The more complex the formula, the more likely you are to need time to get it working
properly. Excel 2003 includes a variety of tools you can use to troubleshoot errors in formu-
las and in worksheets. This section discusses the most useful options.
How Formula AutoCorrect Works
Under most circumstances, Excel won’t let you enter a formula using incorrect syntax. If
you make one of many common mistakes in formula syntax or punctuation, Excel offers to
correct the mistake ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.