Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Cond Formatting < .5 > .5 (Excel 2003)

    Hello - I am trying to write a formula in conditional format for cell A1 to look at C1 for a value between -.5 and .5. How do I do <.5 and >.5 in one formula. Thanks for the help.

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

    Re: Cond Formatting < .5 > .5 (Excel 2003)

    Select Formula Is in the dropdown, and use the formula

    =AND(C1>-0.5,C1<0.5)

    You can use >= and <= instead of > and < if desired.

    Note: if you view this post in the e-mail notification, it may be messed up. Please visit the Lounge itself to view it.

Posting Permissions

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