View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jpzachar jpzachar is offline
external usenet poster
 
Posts: 7
Default data validation using formula result

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