ExcelBanter - Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Validation (https://www.excelbanter.com/excel-discussion-misc-queries/177080-validation.html)

Richard

Validation

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

Gord Dibben

Validation

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

All times are GMT +1. The time now is 08:48 PM.