conditional formatting? you could set the relevant empty cells to a colour
(eg, red) if blank


"CarTel Boy" <CarTel wrote in message
...
Tried to use validation to program a cell to give error msg if left blank
but, it wont. what other options are their for cell programming.