+ Reply to Thread
Results 1 to 3 of 3

Conditional Format - Formula Rule

  1. #1
    Forum Contributor
    Join Date
    02-25-2008
    Location
    Windsor, ON Canada
    MS-Off Ver
    Excel 2007, 2003
    Posts
    119

    Conditional Format - Formula Rule

    I have a column of numbers (column A) which I'd like to compare to an adjacent column of numbers (column B) and, by row, determine if the number is larger. If it is, I'd like to place a different colour on the cell. What is the formula I need to use to accomplish this?

    Ex:
    Col A Col B
    30,000 5,000 - A is larger than B, therefore A is formatted RED
    20,000 20,000 - A is the same as B, therefore no format applied
    10,000 15,000 - A is less than B, therefore A is formatted GREEN

    Thank you!
    Last edited by 2709236; 09-15-2009 at 06:17 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Conditional Format - Formula Rule

    See http://www.contextures.com/xlcondFormat01.html
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    02-25-2008
    Location
    Windsor, ON Canada
    MS-Off Ver
    Excel 2007, 2003
    Posts
    119

    Re: Conditional Format - Formula Rule

    Okay, I feel really dumb now. I wasn't aware that you could put a cell reference in the greater-than/less-than inputs. I thought it required hard-keyed number.

    Thank you for the quick help!

+ 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