Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation input message locatioin has become static | Excel Worksheet Functions | |||
Data Validation Input Message | Excel Worksheet Functions | |||
DataValidationInput message | Excel Worksheet Functions | |||
Input message on data validation field | Excel Discussion (Misc queries) | |||
Data Validation - Location of input message box | Excel Discussion (Misc queries) |