Data validation: Can I use data validation in a cell that has formulas in it?

Hi,

I have attached a sheet that I am working on.

I want cell G1 to be less than or equal to 165. That cell contains a formula. If the formula takes the number to over 165 the validation is allowing it. Any thoughts on what I am doing wrong?

Thanks

Eddie

Yes, data validation only works with manual entries. It does not work with formulas or pasted values.
You can use an IF statement or conditional formatting to flag the cell if it gives a result over 165 or if you just want 165 to be your maximum, you can use this

Please Login or Register  to view this content.