Data Validation

[Platinumkitty]

I am using Excel 2000.

Is there a way in the “Validation†option to look at another cell before the
error message appears?

For example,
If the cell b3 = 250.00 and b4 is less than b3 then and only then should
"Warning Message" or "Error Message" appear.

Thanks in advance for all your help.

Thank you Kitty

 

[davesexcel]

Try it out,
select B4
data,validation,whole number,greater than (or less then)
B3