LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data validation input message locatioin has become static spence Excel Worksheet Functions 2 March 19th 06 09:34 PM
Data Validation Input Message Sandy Excel Worksheet Functions 1 March 8th 06 03:19 PM
DataValidationInput message irresistible007 Excel Worksheet Functions 1 December 3rd 05 01:06 PM
Input message on data validation field Russell-stanely Excel Discussion (Misc queries) 1 August 5th 05 02:41 AM
Data Validation - Location of input message box supergoat Excel Discussion (Misc queries) 5 April 25th 05 04:21 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"