Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (Excell 2003)

    I have an example of a conditional format I am trying to solve. I want to use multiple conditions to change a color using OR. I have my attempt in the cell. The excel file should be self explanatory. Can anyone help?

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

    Re: Conditional Formatting (Excell 2003)

    The second formula should be

    =AND(C1>3,C1<5)

    You want the circle to be green if the number is between 3 and 5, i.e. greater than 3 AND smaller than 5.

  3. #3
    Star Lounger
    Join Date
    Apr 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (Excell 2003)

    Thanks!

Posting Permissions

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