If you're looking for all errors...

Select the range you want to inspect
Edit|goto|Special
check formulas (or constants???)
Only leave the Errors option checked
click ok

Change the fill color of those cells????

If you need a macro, you can record one when you do it manually.

stan wrote:

How to highlight the cells containing #values and #N/A.

--

Dave Peterson