error alert

G

gregork

I want to have an error alert to notify when a cell's value is outside set
parameters. I tried to do this using data validation but it is not working -
I think because the cell is a formula cell not a data entry cell. Any ideas
?????
I'm running excel 2000 by the way.

Cheers
gregorK
 
Top