View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick
 
Posts: n/a
Default Data Validation on a calculated cell

I want to have data validation on a cell containing a formula. Is it
possible to have validation on the results of a formula and how do you do it?
Here is what I'm doing:

A1 (QTY) A2 (UNIT PRICE) A3 (EXTENDED PRICE)

A3 HAS THIS FORMULA =A1*A2

I want to have any value exceeding $5000 in A3 cause a data validation error
alert to appear with a message instructing what to do.