+ Reply to Thread
Results 1 to 2 of 2

Can you have 2 validation rules for one cell?

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Can you have 2 validation rules for one cell?

    In my table i have a cell which has a drop down box with two choices - Yes, No. What i would like is one validation rule which would pop up if you click Yes and a different Validation rule if you click no.

    If yes - Validation rule should say please move to line 20
    If No - Validation rule should say please move to line 19

    Is this at all possible or will i just have to have the one validation rule stating the two options?

    Your help is much appreciated, thank you

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    To the explicit question, no, because that's not what validation is for.

    But how about a cell next to the drop down box with something like:
    =IF(<cell>="Yes","Please move to line 20",IF(<cell>="No","Please move to line 19",""))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to copy cell comments to a new cell?
    By MyBrainhURTS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2009, 11:20 AM
  2. Custom Validation rules
    By de049 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2008, 08:12 AM
  3. Validation Rules
    By stoney1977 in forum Excel General
    Replies: 2
    Last Post: 09-21-2007, 01:45 AM
  4. Data Validation code
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2007, 06:50 PM
  5. More Than One Data validation For the Same Cell
    By cgi_pro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2006, 04:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1