+ Reply to Thread
Results 1 to 7 of 7

If one cell is greater than another, change fill color of other cells. If not, no change

  1. #1
    Registered User
    Join Date
    11-19-2015
    Location
    Michigan, USA
    MS-Off Ver
    10
    Posts
    12

    If one cell is greater than another, change fill color of other cells. If not, no change

    Hello,

    In example 1 - I would like B1,C1,D1 to turn a fill color (green), if G1 is greater. than I1

    In example 2 - I would like B1,C1,D1 to have no fill (stay the same) if, G1 is less than I1 or even

    See attached,

    Thank you in advanced,

    Tony
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,462

    Re: If one cell is greater than another, change fill color of other cells. If not, no cha

    So are these rules meant to be mutually exclusive? What happens if G1 is greater than I1 AND even?

    So far, two rules:

    =$G1>$I1
    =OR($G1<$I1,ISEVEN($G1))
    Last edited by AliGW; 12-19-2018 at 09:44 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,024

    Re: If one cell is greater than another, change fill color of other cells. If not, no cha

    Conditional formatting applied to B1:D1 with colour green and formula =$G1>$I1
    Click the * to say thanks.

  4. #4
    Registered User
    Join Date
    11-19-2015
    Location
    Michigan, USA
    MS-Off Ver
    10
    Posts
    12

    Re: If one cell is greater than another, change fill color of other cells. If not, no cha

    Their can only be 3 out comes:

    1. G1 is greater than I1 - in that case fill color the cells green
    2. G1 is less than I1 - in that case no fill
    3. G1 & I1 are the same - again, no fill

    Hopefully I explained that right.

    Thanks,

    Tony

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,462

    Re: If one cell is greater than another, change fill color of other cells. If not, no cha

    So, you don't mean even, then, but equal to. So, you need to set up three rules:

    =$G1>$I1
    =$G1=$I1
    =$G1<$I1

    EDIT: No, you don't need three rules - you just need one! The other two conditions require no fill, so no rule required.

    =$G1>$I1
    Attached Files Attached Files
    Last edited by AliGW; 12-19-2018 at 10:02 AM.

  6. #6
    Registered User
    Join Date
    11-19-2015
    Location
    Michigan, USA
    MS-Off Ver
    10
    Posts
    12

    Re: If one cell is greater than another, change fill color of other cells. If not, no cha

    Thank you very much, Have a Merry Christmas

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,462

    Re: If one cell is greater than another, change fill color of other cells. If not, no cha

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    Merry Christmas!

+ 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. Change cell fill color for all cells in a workbook based on a cell value
    By HDeuce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2017, 06:01 PM
  2. [SOLVED] Change a cells fill color. VBA to make another cell the same color and also changes.
    By PeteABC123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2016, 12:34 PM
  3. [SOLVED] change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  4. [SOLVED] Change a cell color per greater than/less than formula
    By Steel City in forum Excel General
    Replies: 6
    Last Post: 08-31-2013, 05:55 PM
  5. Replies: 6
    Last Post: 02-16-2013, 05:12 AM
  6. [SOLVED] count the length of each cell in a row and change color if greater than 24
    By mshirley15 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 04:21 PM
  7. Replies: 3
    Last Post: 07-08-2010, 06:48 PM

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