Select E3

DataValidationCustom

=E3<B3

You now cannot enter in E3 a value greater than or equal to B3.

Is this what you want?


Gord Dibben MS Excel MVP


On Mon, 18 Feb 2008 16:11:00 -0800, Richard
wrote:

if e3 < b3 then validation message. How would I write this formula for the
validation message to work. Thanks in advance