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

I don't know if I can still get help on this. The formulas above both made
the pop up come up but I only want it to pop up if both of the criteria are
met. At the moment it is popping up as soon as I click on the cell and
regardless of whether my number is over or under $500 or if it says "General
Expenses" or not.

Can anyone help?

"Klee" wrote:

This is perfect, Thanks so much to you both!

"Klee" wrote:

I would like to use Data Validation to show a message if a cell (E7:E60) is
more than $500 but I only want it to pop up if a different cell (b3) says
"General Expenses".

If anyone can help it would be much appreciated
Thanks