Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF(Logical=this OR that),'X',' ' (2000/9.0)

    Cell A1 is Validated with 6 possible answers.
    Cell A2 should be blank if Cell A1 is blank or 2 of the answers.
    Cell A2 should have an X if Cell A1 is any of the other 4 answers.
    I feel fairly sure there is an easy way to do this using IF and OR, but darned if I can figure it out!
    Any help would be muchly appreciated!

    Also, I would love to make the cell background in A2 change color depending on the contents of cell A1.
    Again, I'm fairly sure there is an easy way to do this using Conditional Formatting.
    Any help there would be muchly appreciated as well.

    Thanks in advance to anyone who can get me up and running.

    RJD

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: IF(Logical=this OR that),'X',' ' (2000/9.0)

    You didn't give a lot of specifics, but here is a general answer

    in a2 something like:
    =IF(OR(A1=answer1,A1=answer2),"",IF(OR(A1=answer3, A1=answer4,A1=answer5,A1=answer6),"X","No Answer"))

    For conditinal formating select A2 and use
    formula is:
    =OR(A1=answer1,A1=answer2)
    <format>
    change the format you want with A1 = answer1 or answer2
    <add>
    Formula is
    =OR(A1=answer3,A1=answer4,A1=answer5,A1=answer6)
    <format>
    change the format you want with A1 = on of answer3 -answer6

    Steve

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF(Logical=this OR that),'X',' ' (2000/9.0)

    Thank you SO much! That did exactly what I wanted with the first one. For the formatting, I think I've decided not to use it. If I rethink that (yet again!) I may be back for clarification so I can apply your answer to my specific situation.

    THANKS!!!
    R--

Posting Permissions

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