Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Platinumkitty
 
Posts: n/a
Default 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