Validation

[Richard]

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

 

[Gord Dibben]

Select E3

Data>Validation>Custom

=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