LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default data validation based on cell value

Hello......I hope you can help....thanks in advance!

I would like to have an error message pop up if the result of a formula in
cell N100 is greater than 5. I tried using the data validation and "custom"
selection but could not get it to work. Is this possible?

thanks,
Jeff
 
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
Hide/Show Rows based on Cell Value with Data Validation Shelly Excel Programming 3 January 4th 08 11:01 PM
Data Validation based on data to left but several columns dependen MarvInBoise Excel Programming 3 June 20th 07 12:59 AM
Creating a Data Validation List based on a Value in another cell LondonLion Excel Worksheet Functions 2 June 8th 07 12:23 AM
data validation to restrict input in cell based on value of cell above that cell NC Excel Programming 2 January 25th 05 07:11 AM
Sorting data based on validation cell JanetP[_2_] Excel Programming 1 January 7th 04 05:39 PM


All times are GMT +1. The time now is 10:40 AM.

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"