Hello all,
Using excel 2000, how can I put a validation on cell A1 where the user can only enter any number in it IF the sum of cells B1:E1 is less than 5? If the sum of the cells is greater than 5, I don't want the user to be able to enter anything in A1.
Thanks.
Using excel 2000, how can I put a validation on cell A1 where the user can only enter any number in it IF the sum of cells B1:E1 is less than 5? If the sum of the cells is greater than 5, I don't want the user to be able to enter anything in A1.
Thanks.