Error Checking

[TW0T0ES]

Hey All,

I have an excel sheet that many different people use/update with different versions of Excel and/or Open Office. They are constantly breaking the formulas so I just want a simple error check.

I want ONE cell to turn red and say "SHEET CONTAINS ERRORS" if any cell in a range contains an error. Currently I have 6 or 7 cells setup with all the different errors...

=IF(COUNTIF(F1:BA34,"#NAME?")>0,"T","F")
=IF(COUNTIF(F1:BA34,"#VALUE")>0,"T","F")
=IF(COUNTIF(F1:BA34,"#NUM!")>0,"T","F")

and so on...

then my cell that turns red setup with

=IF(COUNTIF(F36:F43,"T")>0,"SHEET CONTAINS ERRORS","") and Conditional Formatting..

I would just like to know if this will work, everytime, and if there's a better/easier/more stable way.


Sorry if this is a noob question, but I just can't figure this out.

 

[ParamRay]

.
.

Excel's built-in ISERROR function checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) and returns TRUE or FALSE.