Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default Data Valadation

I have the following Data
Col A Col B Col C
2 3 =A1-B1

The user enters data in Cell A1 Or Cell B1 and Cell C1 Calculates the results

I want the following
If the user enters any value in Cell A1 Or Cell B1 and the Value computed in
Cell C1 returns to Negative . he gets a pop up saying "Invalid Range"

Eg in the above Cell C Will Return -1 in such case I want to get a pop up In
valid Range
If Cell C1 Is Positive no message should be displayed

I tried Data Valadation but It does not work with Formulas . . . Or Does it
work with Formula which I am not aware of ?

Thank You

 
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
Using a Hyperlink with Data Valadation Trackeous Excel Discussion (Misc queries) 0 November 30th 06 04:51 PM
Using a Hyperlink with Data Valadation Scott@CW Excel Discussion (Misc queries) 0 November 30th 06 04:07 PM
populate data valadation list by criteria John in Surrey Excel Worksheet Functions 1 November 9th 05 10:07 AM
Data Valadation - KimberlyC Excel Worksheet Functions 1 June 2nd 05 09:29 PM
Data Valadation help KimberlyC Excel Worksheet Functions 2 April 18th 05 01:24 AM


All times are GMT +1. The time now is 06:46 PM.

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

About Us

"It's about Microsoft Excel"