View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Klee Klee is offline
external usenet poster
 
Posts: 67
Default Data Validation Input Message

I tried to get back and reply on my last question but was unable to so I had
to start a new question. I'm trying to use the data validation to make a pop
up come up in a cell (e7) if two criteria are met. One is if B3="General
Expenses" and the other is if e7 is more than $500.

I got a couple of formulas from my previous question. The problem is that as
soon as you click on the cell the message pops up. This happens whether the
cell is blank or over or under the $500 and regardless if B3 says "General
Expenses" or not.
Is there a way to get the pop up only if the other criteria are met? Thanks
again!