+ Reply to Thread
Results 1 to 3 of 3

If a cell on this list matches on another list, conditional format based on another column

  1. #1
    Registered User
    Join Date
    05-16-2017
    Location
    Minnesota
    MS-Off Ver
    Professional Plus 2013
    Posts
    9

    Question If a cell on this list matches on another list, conditional format based on another column

    On Master sheet, I have the ID's and group numbers in a table. As new ID's are added, this list will be updated.

    On Jan sheet and will also all months on sheets, will be a running list of ID's with other info that has been removed for sterilization purposes.

    What I want to do is have a conditional format that looks at column A on the month sheet and have it look back at the master sheet and then the group # that it is assigned having 3 different fill colors. So adding other ID's to the month table will auto fill it as it gets added to the table.

    I have attached a sample spread sheet of what I am looking at doing as well as attached a picture of what I would like the final outcome of the month tab to be.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-16-2017
    Location
    Minnesota
    MS-Off Ver
    Professional Plus 2013
    Posts
    9

    Re: If a cell on this list matches on another list, conditional format based on another co

    I have not yet figured out how to do this, I can label the ID's on the master tab based on its group if that helps on trying to get the ID's filled in the month tabs.

  3. #3
    Registered User
    Join Date
    05-16-2017
    Location
    Minnesota
    MS-Off Ver
    Professional Plus 2013
    Posts
    9

    Re: If a cell on this list matches on another list, conditional format based on another co

    I figured it out that I was doing my IF INDEX MATCH conditional formatting wrong. I took the IF statement out and using the INDEX MATCH as its own IF statement within the conditional formatting using...

    =INDEX('EMP ID'!D:D,MATCH(A2,'EMP ID'!A:A,0))=3

    Having a different format for each color and changing the =3 to either be 1 or 2.
    Last edited by AliGW; 03-01-2019 at 02:09 PM.

+ 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. Conditional Format to Add List of Text Based Upon Cell Contents
    By mkedyr1969 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2015, 11:58 AM
  2. Replies: 0
    Last Post: 08-08-2014, 12:12 PM
  3. Replies: 4
    Last Post: 01-22-2014, 12:37 AM
  4. Conditional Format ROW based on text in drop-down list
    By Kwillz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2013, 12:08 AM
  5. Replies: 4
    Last Post: 03-17-2010, 11:10 AM
  6. Conditional Format Dates in a Calender when Matches dates in a list
    By Lungfish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2009, 06:23 AM
  7. Conditional Format based on a list
    By melnikok in forum Excel General
    Replies: 4
    Last Post: 08-07-2008, 03:33 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