Good morning Sandy

It is possible, but why not use the easier route of using Excel's validation feature. Data > Validation will allow you to set parameters up for any individual cell, and the validation rules will be checked whenever the user attempts to leave a cell.

HTH

DominicB