Results 1 to 6 of 6

Thread: Formatting (XP)

  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Formatting (XP)

    I have to do some conditional formatting
    But I have more then 3 conditions. When the value in the cell is either T-9 or 10 the cell should go green, when the cell content is either C6, 7 or 8 it goes orange and when its S1, 3,4 or 5 it should go red.

    I have no problems making it conditional using just the T C or S, but I don't know how to do it when there are 9 conditions.

    Can someone please help
    Thanks so much
    Cheers

  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: Formatting (XP)

    Check out more then 3 conditions with conditional formatting (XP/2003)

    Steve
    PS: do you have 9 conditions and 3 formats or 9 different formats? it is the number of formats (you can have only 4: an explicit and 3 conditional) that is the issue, not the conditions...

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Formatting (XP)

    I have 9 conditions and 3 formats
    Perhaps I have to have very small columns, put the T in one column and the 9 or 10 in another and figure out a way to have both cells look as one...
    Amazing isn't it, excel is so complex and then it doesn't do what I want [img]/forums/images/smilies/smile.gif[/img]
    Thanks for sending that link anyway

  4. #4
    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: Formatting (XP)

    if the conditions are what you describe (and I understand it correctly)

    You can have the conditions (assuming the cell selected is A1
    Formula is
    =or(A1="T-9", A1="T-10")

    Formula is
    =or(A1="C6", A1="C7", A1="C8")

    Formula is
    =or(A1="S1", A1="S3", A1="S4", A1="S5")

    And set the formats appropriately

    [If there is more than 1 cell to format, then select all of them and use the active cell as the reference in formulas, it will be set to all in a relative manner]

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatting (XP)

    The limit on conditional format isn't really three conditions - it is three formats. You can combine more than one logical test with a logical AND or an OR to form the condition that will trigger a particular format. I wasn't sure whether you meant that the value of the cell would be the literal (string) value of -say- "S1" or it would be equal to the value in cell S1 (etc). I assumed the former, but the approach would be the same. The test for one of the conditional formats will be something like (for the cell B4 - obviously that part changes as required):
    <pre>"Formula Is"
    =OR(B4="S1",B4="S2",B4="S3",B4="S4")</pre>


    the condition would evaluate as "TRUE" if the cell takes on any of the values "S1" through "S4" and in this case would apply a red pattern: other conditions would apply the appropriate green or orange colour.

    If you wanted to test for equality with the values in Cell S1 (etc) you would change the condition so it wasn't testing for a match with the string value "S1" (etc), but just whether B4=S1 (etc).
    Attached Files Attached Files

  6. #6
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Formatting (XP)

    WOW... that worked like a treat..
    Thanks heaps

Posting Permissions

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