+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting - The Greater of 2 Cells = Green

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2010
    Posts
    50

    Conditional Formatting - The Greater of 2 Cells = Green

    Hi,

    Comparing 2 cell values, I wish to make the greater value green.

    A1=1
    A2=2

    A2 will be green. A1, no fill.

    Easy for you. Not for me.

    Thanks,

    Jon

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Conditional Formatting - The Greater of 2 Cells = Green

    Try this...

    Select cells A1:A2 starting from cell A1

    Goto the Home tab>Styles>Conditional Formatting>
    Manage rules>New rule>Use a formula to determine
    which cells to format

    Enter this formula in the box below:

    =AND(A1<>"",A1=MAX(A$1:A$2))

    Click the Format button
    Select the desired style(s)
    OK out
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Contributor yay_excel's Avatar
    Join Date
    08-12-2011
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    190

    Re: Conditional Formatting - The Greater of 2 Cells = Green

    Conditional formatting formula for column A: =$A1>$B1
    Conditional formatting formula for column B: =$B1>$A1

    Make sure the active cell in your selection is in row 1 when you apply the conditional formatting.

    Let me know if you need further help implementing.

  4. #4
    Registered User
    Join Date
    04-29-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Conditional Formatting - The Greater of 2 Cells = Green

    Thanks, Tony and yay.

    Tony, your formula did the trick...as usual! Thanks for your help...as usual!

    yay, I'll have to play with your formula since it pertains to different columns. Thanks for your input.

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Conditional Formatting - The Greater of 2 Cells = Green

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-27-2015, 01:35 PM
  2. Replies: 1
    Last Post: 01-06-2014, 04:31 AM
  3. Replies: 5
    Last Post: 07-13-2013, 04:07 PM
  4. [SOLVED] Conditional formatting if equal or greater than average in the range of cells
    By Abu Abdurakhim in forum Excel General
    Replies: 7
    Last Post: 05-28-2013, 10:01 AM
  5. How to hide cells if the conditional formatting in column A has made them Green
    By Triscia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2013, 12:22 PM
  6. Conditional Formatting Greater than surrounding Cells
    By tmiller in forum Excel General
    Replies: 1
    Last Post: 03-30-2007, 12:15 PM
  7. Conditional formatting for the greater of 7 cells
    By guest123 in forum Excel General
    Replies: 8
    Last Post: 01-15-2007, 01:39 PM

Tags for this Thread

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