Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting (2003)

    Hi All,

    I would like to know if it is possible to use conditional formatting for more than 3 conditions per cell. I think it is not and if thats true is it possible to group conditions.

    Example: Lets say I have a key (legend) for my spreadsheet, The Key contains the Codes and there descriptions, the Codes are what I will fill in on the main table.

    The codes are LD, L, E, N, BE, BL, AL

    Is it possible to group LD, L, E, N as one condition
    And BE, BL as another
    And AL As another

    Many thanks
    Kevin
    Regards
    Gerbil (AKA Kevin)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting (2003)

    Let's say that you want to apply conditional formatting to B2:B100.
    - Select B2:B100
    - Select Format | Conditional Formatting.
    - Select Formula Is from the first dropdown.
    - Enter the following formula in the box next to it:

    =OR(B2="LD",B2="L",B2="E",B2="N")

    - Click Format... and specify the desired formatting, then click OK.
    - Click Add >> to add a second condition.
    - Select Formula Is from the first dropdown.
    - Enter the following formula in the box next to it:

    =OR(B2="BE",B2="BL")

    - Click Format... and specify the desired formatting, then click OK.
    - Click Add >> to add a third condition.
    - Select Cell Value Is from the first dropdown.
    - Select equal from the second dropdown.
    - Enter ="AL" in the box next to it.
    - Click Format... and specify the desired formatting, then click OK.
    - Click OK.

    If you really need to specify more than 3 non-grouped conditions, you'd need VBA code.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2003)

    Thats great thanks Hans I was trying LD Or L Or E etc etc

    I would much Prefer a different condition for each but I thought it would not be possible so I went for grouping.

    How would I go about VBA in excel is it like the Macro I did in Word

    Thanks again
    Kevin
    Regards
    Gerbil (AKA Kevin)

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2003)

    Hi Kevin

    The posts here <post#=685818>post 685818</post#> and <post#=557373>post 557373</post#> will provide you the information you need.
    These are WorkSheet Change event procedures

    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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