LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 91
Default Data validation custom formula

I don't really want to use a list for this data validation problem because I
have 240 items for the list. Six of those items I want to display a message
if they are entered. What kind of formula do I use for this or do I have to
use a list?

In addition (as long as I'm asking) if I wanted a warning message to come up
if the item number was invalid (I assume I need a list then) can you put two
data validation formulas for the same cell reference? I would want both of
the above conditions met with messages.
 
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
Custom Data Validation Steve E Excel Discussion (Misc queries) 1 September 2nd 06 10:16 PM
Data Validation - Custom Mary Ann Excel Discussion (Misc queries) 4 December 17th 05 09:22 PM
Data Validation - Scroll in the formula bar for a custom criteria Hanno Scholtz Excel Worksheet Functions 3 September 22nd 05 02:11 PM
Data Validation - Custom - Formula DYeomans Excel Worksheet Functions 2 May 2nd 05 05:21 AM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 11:29 AM


All times are GMT +1. The time now is 12:08 AM.

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"