View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Validation of cell results

Your description is a little thin on details but in general you are probably
looking to use the Custom option in data validation. You specify a formula
and off you go...
--
HTH...

Jim Thomlinson


"jpreman" wrote:

Thanks for reading this post.

Data/validation is used for data entry in a cell.

Is there a way validations could be applied based on the results in a cell.
ie. if a desired result is not reached there should be a customised error
message/alert