+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting and Greater than BUT less than

  1. #1
    Forum Contributor dagindi's Avatar
    Join Date
    06-02-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    295

    Conditional Formatting and Greater than BUT less than

    I am trying to use Conditional Formatting to highlight cell values as follows:

    <=30% - RED
    >30% but <=69% - YELLOW
    >69% - GREEN

    I came across a THREAD that helped me solve the "<=30% - RED" using =(ABS(B$2-C2)/B$2)<=0.3 and ">69% - GREEN" using =(ABS(B$2-C2)/B$2)>=0.7

    I can't figure out how to do the ">30% but <=69% - YELLOW". I could just leave it blank but that would be the easy way out.

    So how do I write it so that =(ABS(B$2-C2)/B$2)>0.3 but less than 0.7 fills in yellow.

    Attached is an example.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Conditional Formatting and Greater than BUT less than

    =and((ABS(B$2-C2)/B$2)>0.3,(ABS(B$2-C2)/B$2)<0.7)

    Instead of calculating tthe value just use the value of the E col as condition ( fi =E5<0,3, etc...)
    Last edited by arthurbr; 06-07-2010 at 03:10 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1