+ Reply to Thread
Results 1 to 4 of 4

Small issue with data validation

  1. #1
    Forum Contributor
    Join Date
    11-05-2012
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    107

    Small issue with data validation

    Hello,

    I have developed a dropdown list composed of the following elements:
    Planned Compliant
    Verified Compliant
    Not Compliant
    Planned Compliant per Waiver (see note)
    Verified Compliant per Waiver

    Then by using data validation i assigned to each the following colors:
    Planned Compliant ----- yellow
    Verified Compliant ----- green
    Not Compliant ------ red
    Planned Compliant per Waiver (see note) ----orange
    Verified Compliant per Waiver ------blue

    Ok so everything works a part the fact that when i choose:
    Verified Compliant ---- the colour is green
    Verified Compliant per Waiver ---- the colour is green instead of blue

    Whant should i do? Apparently the system is confusing ''Verified Compliant per Waiver '' with ''Verified Compliant'' since they are very similar.


    Thank you

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Small issue with data validation

    I don't get an wrong color if I test it.

    See the attached file.

    I tested it with the words test and test1
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    11-05-2012
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Small issue with data validation

    A thanks oeldere what i did is using format only cells that contain specific text. You used contain cell value equal to.
    Any ways. Prb solved..

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Small issue with data validation

    Thanks for the reply.

    Glad I could help.

    Will you mark the question as solved?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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