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.
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.