+ Reply to Thread
Results 1 to 2 of 2

Conditional Matching Multiple Cells

  1. #1
    Registered User
    Join Date
    01-26-2018
    Location
    Midwestern US
    MS-Off Ver
    2016
    Posts
    1

    Conditional Matching Multiple Cells

    I've tried searching for a solution to my issue, as I'm sure there's information out there, but I can't seem to hit upon the proper query string to find what I want.

    I am working on a workbook that consists of several tabs that contain the answers that students provided on quizzes. There is a column with the name of the quiz (there are three different quizzes per class, all stored on the same sheet) and then a column for each question from the quiz (3-5 questions per assessment).

    TITLE | STUDENT | QUESTION1 | QUESTION2 | QUESTION3 | QUESTION4 | QUESTION5


    I have another similar sheet that serves as a key, with the correct answers for each question.

    What I would like to do is change the color of a cell if the answer is incorrect. So I would first need to check the Title column to see which row in the key contains the correct answers, then I would need to check the cell in that row that contains the answer, then change the color if the answer provided by the student doesn't match the cell containing the correct answer.

    What is the most efficient way to accomplish this?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,079

    Re: Conditional Matching Multiple Cells

    Condtional Formatting using VLOOKUP or INDEX ( MATCH() ).

    Prob best provide a file as you haven't specified the layout ("There is a column with the name of the quiz" - ok, where?)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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] Conditional formatting with multiple/matching criteria.
    By gz3s36 in forum Excel General
    Replies: 7
    Last Post: 09-06-2017, 06:58 AM
  2. [SOLVED] Conditional formatting by matching parts of cells
    By jilaba in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2017, 01:54 PM
  3. Multiple cells, multiple sheets, multiple criteria matching
    By Drudnits1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2014, 12:12 PM
  4. Replies: 4
    Last Post: 07-25-2014, 05:17 AM
  5. Replies: 5
    Last Post: 09-05-2013, 08:59 AM
  6. Replies: 2
    Last Post: 08-27-2011, 03:05 PM
  7. Excel 2007 : matching cells with conditional formatting
    By strokedmaro in forum Excel General
    Replies: 2
    Last Post: 06-20-2010, 06:03 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