+ Reply to Thread
Results 1 to 7 of 7

color change for matching value cells

  1. #1
    Registered User
    Join Date
    01-18-2016
    Location
    Burlington, VT, USA
    MS-Off Ver
    2013
    Posts
    3

    color change for matching value cells

    I have 2 cells that IF they DO NOT match numerically I want them to change fill color (a warning flag), I know it's done through conditional formatting but I can only find how to do it with matching cells. Any help would be appreciated.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,786

    Re: color change for matching value cells

    Which are the two cells? We can't give you a formula if we don't know which cells it should refer to. Attach a sample workbook (the FAQ describes how to).

    Pete

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,615

    Re: color change for matching value cells

    Hi, welcome to the forum

    1. highlight the range you want to apply the conditional formatting to (A1)
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =A1=B1

    click on B1 and Repeat 3 and 4

    Oviously adjust those ranges to suite
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    01-18-2016
    Location
    Burlington, VT, USA
    MS-Off Ver
    2013
    Posts
    3

    Re: color change for matching value cells

    I have a SUM formula in I10 and a SUM formula in I13, when the sums in each DO NOT match I would like cells I10 and I13 to turn red.
    Last edited by DanPop; 01-18-2016 at 03:15 PM.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,786

    Re: color change for matching value cells

    Select cell I10, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the box:

    =$I$10<>$I$12

    Click the Format button | Fill tab and choose red, then click OK twice to exit. You can use the Format Painter icon to copy the format from I10 into I12 if you want both cells to show red.

    Hope this helps.

    Pete

  6. #6
    Registered User
    Join Date
    01-18-2016
    Location
    Burlington, VT, USA
    MS-Off Ver
    2013
    Posts
    3
    Quote Originally Posted by Pete_UK View Post
    Select cell I10, then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the box:

    =$I$10<>$I$12

    Click the Format button | Fill tab and choose red, then click OK twice to exit. You can use the Format Painter icon to copy the format from I10 into I12 if you want both cells to show red.

    Hope this helps.

    Pete
    Thank you Pete

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,615

    Re: color change for matching value cells

    oops *not match*, not *match*
    Thanks Pete

+ 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. [SOLVED] Change Color of Sheet Tabs by Matching Cell Colors
    By mgaworecki in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2014, 10:11 AM
  2. [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
  3. Color cells if matching value exists
    By rainbowforest in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2011, 02:53 PM
  4. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  5. Match & change color of matching text only
    By PolishPaul in forum Excel General
    Replies: 4
    Last Post: 12-06-2009, 06:15 PM
  6. Change color when matching a value in the cell
    By sub1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2006, 04:31 PM
  7. [SOLVED] Color background with Matching cells in row
    By Diggsy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2006, 05:10 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