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