data validation using formula result
Thanks Shane.....is it possible to do this using data validation so that I
can use an error message box?
thanks in advance!
"ShaneDevenshire" wrote:
Hi,
Try this
=IF(COUNTIF(C100:M100,"<0")=5,"Error",COUNTIF(C1 00:M100,"<0"))
if this helps, please click the Yes button
--
Thanks,
Shane Devenshire
"jpzachar" wrote:
Hello....hope you can help....thanks in advance!
I have a formula which is =COUNTIF(C100:M100,<0). I want to show an error
message box when the result of this formula equals greater then 5. Is this
possible? The formula is in cell N:100
thanks,
Jeff
|