Highlight default errors (like #Value!)

August 15th, 2004 | Categories: Formatting | Tags:
-->

Make your errors really stand out with this Conditional Formatting trick.

1. Select the entire sheet
2. On the main menu click Format then Conditional Formatting…
3. Change “Cell Value Is” to “Formula Is”
4. In the box to the right of “Fomula Is” type =ISERROR(A1)
5. Click the Format button…
6. Select the Format tab and pick a color, hit OK, hit OK

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
No comments yet.