+ Reply to Thread
Results 1 to 2 of 2

Conditional Format Column based on Lookup to Diff. Sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Pittsburgh, PA
    MS-Off Ver
    MS Office 2010
    Posts
    64

    Conditional Format Column based on Lookup to Diff. Sheet

    Hello all,

    I was wondering if it were possible to do a conditional format on a column based on a reference to a different sheet. For example, I have a table in my first sheet with attributes. Any time an attribute is used by a specific code, I mark an X in the cell for that code. Now, I want to be able to highlight those X's in red if they match the standard attributes for that code in the second sheet. In the attached sheet, the scale has been significantly reduced to make it easier to see, but I plan on doing this for a much larger data set. Any help would be greatly appreciated!

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Conditional Format Column based on Lookup to Diff. Sheet

    Hello
    Select the range of cells and apply the following CF formula:

    =COUNTIF(INDEX('Ref. Table'!$B$2:$G$13,0,MATCH(B$1,'Ref. Table'!$B$1:$G$1,0)),$A2)
    Whatever font format you've chosen should be applied.

    DBY

+ 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 an Entire Column based on percentage of another Column
    By Nolson24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 09:23 AM
  2. [SOLVED] Conditional format based on 3 way lookup
    By Tank997 in forum Excel General
    Replies: 4
    Last Post: 06-30-2013, 04:36 PM
  3. Replies: 2
    Last Post: 01-13-2013, 06:50 AM
  4. Conditional formatting based on value in diff sheet
    By shikamikamoomoo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2010, 12:02 AM
  5. Conditional delete based on cell in same row, diff column
    By jessjess in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2009, 08:22 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