View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jpzachar jpzachar is offline
external usenet poster
 
Posts: 7
Default data validation based on cell value

Hello......I hope you can help....thanks in advance!

I would like to have an error message pop up if the result of a formula in
cell N100 is greater than 5. I tried using the data validation and "custom"
selection but could not get it to work. Is this possible?

thanks,
Jeff