+ Reply to Thread
Results 1 to 4 of 4

How to Conditional Format Data in One Table Based on Values from Another?

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    Cork, Ireland
    MS-Off Ver
    14.4.3
    Posts
    2

    How to Conditional Format Data in One Table Based on Values from Another?

    Hi Guys,

    I'm trying figure out how to conditionally format the data in one table based on the criteria specified in another table on a different worksheet.

    The Table I'm trying to format has a series of Products and Volumes that'll be available on different dates.
    Table 1.jpg

    The Criteria table has each product and a corresponding Key Data.
    Table 2.jpg

    All I want to be able to do is have the cell corresponding to the criteria to be highlighted but can't for the life of me figure out how to do it.
    If it makes a difference I'm working offAttachment 338501 a Mac. Excel Version 2011 14.4.3
    Appreciate any help
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: How to Conditional Format Data in One Table Based on Values from Another?

    conditional formatting gets pretty tricky because of the way absolute vs. relative references translate...

    the formula I think you're looking for is actually:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and it applies to $b$3:$k$9

    as in the attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-12-2014
    Location
    Cork, Ireland
    MS-Off Ver
    14.4.3
    Posts
    2

    Re: How to Conditional Format Data in One Table Based on Values from Another?

    This is it exactly.
    Thanks Simarui, you've no idea how much that was irritating me

  4. #4
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: How to Conditional Format Data in One Table Based on Values from Another?

    I think I may have some idea... conditional formatting has irritated me many, many times.

    don't forget to mark the post solved.

+ 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: 5
    Last Post: 10-24-2013, 05:34 PM
  2. [SOLVED] Conditional format based on being outside of two ranges of values - forecast
    By tomstheword in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-18-2013, 06:34 AM
  3. Conditional Format between two values based on another value
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2013, 03:57 AM
  4. [SOLVED] Conditional format based on ISTEXT and ISBLANK values
    By JDobbsy1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-29-2012, 06:48 PM
  5. [SOLVED] Conditional format for duplicate values based on criteria in a different cell
    By excelheaven in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2012, 11:34 AM

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