Validation list display
Results 1 to 2 of 2

Thread: Validation list display
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2010
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Validation list display

    Hi,

    I am trying to setup a number of cells with a validation list allowing "Yes" or "". I would like the cell value to equal 1 when "Yes" is selected. Is this possible without VBA?

    The reason for this is because I want to set up conditional formatting with the tick, cross, exclamation mark icon set (With a tick appearing for "Yes"), but this conditional formatting only works with numerical values.

    Thanks,
    H

  2. #2
    MrExcel MVP DonkeyOte's Avatar
    Join Date
    Sep 2002
    Location
    Suffolk, UK
    Posts
    9,118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Validation list display

    Create the list as follows:

    In A1 type 1 - apply Custom Cell Format to A1 of: "Yes"
    In A2 type 0 - apply Custom Cell Format to A2 of: "No"
    repeat if nec. for other options

    Create your Validation cell and tie to contents of A1:A2

    You should find that when you select Yes the number 1 appears (0 for No).
    Does my a$$ look big in this picture ?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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