+ Reply to Thread
Results 1 to 6 of 6

Is there a function that can color a block if that block is higher than another block?

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Groningen
    MS-Off Ver
    Excel 2007
    Posts
    5

    Is there a function that can color a block if that block is higher than another block?

    The title pretty much says it all.
    Thank you in advance!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,771

    Re: Is there a function that can color a block if that block is higher than another block?

    Not quite sure what you mean by "block" but sounds like you're looking for CONDITIONAL FORMATTING.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-04-2012
    Location
    Groningen
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Is there a function that can color a block if that block is higher than another block?

    I mean a square like A1 or B5. I'm looking for a method to compare results (for example football results).
    If I have these columns :
    A B
    5 1
    2 0
    1 3
    2 1
    Than I would like for A1,2 and 4 to automatically receive a green color (BG not text).
    I'm not familiar with the function last mentioned.
    Kind regards,
    Apparas.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,771

    Re: Is there a function that can color a block if that block is higher than another block?

    Conditional Formatting: =A1>B1 format as green.


    Regards, TMS

  5. #5
    Registered User
    Join Date
    10-04-2012
    Location
    Groningen
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Is there a function that can color a block if that block is higher than another block?

    Thank you for your quick reply. This worked for once cell at a time. However, I'm wondering if I can apply this to a whole column? I have not yet found a way to achieve this.
    Kind regards,
    Apparas.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    30,771

    Re: Is there a function that can color a block if that block is higher than another block?

    Select the whole column first, starting with cell A1. Then apply the CF.

    Regards, TMS

+ 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