Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Conditional Formatting (2000 SR1)

    Hi,

    I'd like to warn users that their figures don't make sence by using conditional formatting.

    I'd like cell C1 to turn coulour if either of the following occur:

    If Cells A1 and B1 have the same number in them and C1 <> 1
    or
    If Cells A1 and B1 have different number in them and C1 = 1

    ie:
    <pre>A1 B1 C1 C1 colour
    1 2 1 red
    1 2 2 green
    1 2 3 green
    1 1 1 green
    1 1 2 red
    </pre>


    I've searched but I can't seem to work out a single condition that will satisfy the above. Do I have to use separate conditions?

    Jim
    Shetland Isles

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

    Re: Conditional Formatting (2000 SR1)

    Select cell C1.
    Select Format | Conditional Formatting... from the menu.
    Select Formula Is from the dropdown list.
    Enter the formula

    =OR(AND(A1=B1,C1<>1),AND(A1<>B1,C1=1))

    Click Format... and set the formatting you want.
    Click OK (twice).

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Conditional Formatting (2000 SR1)

    Fantastic!

    Thank you, you've saved me (another) hour of head scratching.

    Jim

Posting Permissions

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