Data Validation - Custom
Thank you - works great.
"Bob Phillips" wrote:
Mary Ann wrote:
How do I use the custom validation. I want to enter a validation which does
not allow the cells in column G to be more than the cell on the same row in
column E + 50.
I have selected all the cells, gone to Data Menu, Validation. Then on the
Settings tab picked Custom and then need to type the formula. Ive treid a
few but cant seem to get it right.
Mary Ann,
Select G1, DataValidation, Custom type and add a formula of
=G1<=E1+50
Then select the other cells including G1, go back to DataValidation,
and you will get a message asking to extend. Say yes.
HTH
Bob
|