+ Reply to Thread
Results 1 to 2 of 2

change background if two rows matches

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    Mississauga
    MS-Off Ver
    10
    Posts
    1

    change background if two rows matches

    Numbers in cell G7-K7 are first arranged in ascending order in M7 to Q7 through formula: =SMALL(G7:K7,{1,2,3,4,5,6})
    and similarly G8-K8 and goes on.

    Table M7:Q10
    If M7-Q7 (1,3,6,9,12) appears in same sequence in Table A7:E16 is TRUE then the background may change color to yellow, else back ground remains white.

    As I have highlighted manually M8 to Q8 appears in the same sequence so both backgrounds are highlighted, similarly with M10 to Q10.

    How can I do this through a formula.

    See attached file : (CHECK)
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: change background if two rows matches

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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: 8
    Last Post: 04-02-2016, 04:00 AM
  2. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  3. [SOLVED] Macro to change all cells with a certain background color in another background color
    By kevinvzandvoort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 11:04 AM
  4. [SOLVED] Locating Matches & Highlighting Background
    By Old Dog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2006, 08:25 PM
  5. [SOLVED] change background row color with change of date in a cell
    By Urszula in forum Excel General
    Replies: 5
    Last Post: 05-17-2006, 03:00 AM
  6. Replies: 5
    Last Post: 07-29-2005, 03:05 PM
  7. Change Background
    By DonHuff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2005, 09:05 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