Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Multi-Level Data Validation

Latest post Thu, Mar 20 2008 2:12 PM by Jim Thomlinson. 0 replies.
  • Thu, Mar 20 2008 2:12 PM

    • Jim Thomlinson
    • Top 10 Contributor
    • Joined on Thu, Jan 10 2008
    • Vancouver, Canada
    • Posts 84
    • Points 1,256

    Multi-Level Data Validation

    Right now there you can apply one validation to a cell. The validation can be either a Stop, Warning or Information. I would like to be able to apply multiple levels of validation to a cell. Have an info message if a number is a bit too high. Have a warning message if it is a lot too high. Have a stop if it is beyond possible.

    Additionally lets say I want to allow integers between 0 and 100 with a warning when you get outside of those bounds. If the User enters Text then apply a stop. 

    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.