DonkeyOte
Thanks for the quick reply. Your solution works for an individual cell, but I need to check a range of cells C2:C2001. The outlier may or may not reside in C2.
The formula:
=IF(Stats!C2:2001,"ERROR","")
Does not pick up an outlier in cell C20.
The formula:
=IF(Stats!C20,"ERROR","")
Works great but only for that particular cell. Do I have to enter the same formula 2,000 times for each individual cell?
Any help is appreciated.
Bookmarks