data validation
Posted by Matt T on January 23, 2002 10:38 AM
how do you do data validation when the cell you want to set the maximum value of has a formula in it?
Posted by Dan on January 23, 2002 10:52 AM
You want to put the data validation not on the cell with the formula, but on the cell that you are actually entering the value in. For instance: you have in cell A1 the value 100, you enter a variable number in B1, and in C1 you have the formula =A1-B1. You don't want C1 to ever be negative. You don't do the validation in C1, you instead put the validation formula in B1: =A1-B1>=0. Does that make sense?
If you provide an example, I will be able to explain it better.
HTH
