Data Validation
 

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

Data Validation
 

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522009