+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting with INDEX/MATCH

Hybrid View

  1. 01-18-2013, 11:18 AM #1
    Shanster695
    Shanster695 is offline
    Registered User
    Join Date
    01-14-2013
    Location
    Hamilton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    8

    Conditional Formatting with INDEX/MATCH

    Well I am positively stumped!

    I'm trying to index the part numbers on the sheet named "Parts" and if any of the parts labelled TYP (for Typical) I want the part name in the second sheet "Typical" to flag green.

    I have tried VLOOKUP, MATCH, INDEX, COUNTIF.

    The closest I got was with with MATCH and INDEX but it started doing this weird thing where it would flag green through Conditional Formatting if there was any text entered in corresponding cells (Parts!C9,Typical!C9)

    See the attached file.

    HELP! FEWA Receiving Tracker.xlsm
    Reply With QuoteRegister To Reply
  2. 01-18-2013, 10:45 PM #2
    p24leclerc
    p24leclerc is offline
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Conditional Formatting with INDEX/MATCH

    Sorry but I don't understand what you want to do. I see the exact same part # in both tab. Can you give us some more details?
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.
    Reply With QuoteRegister To Reply
  3. 01-18-2013, 11:45 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Conditional Formatting with INDEX/MATCH

    CF does not work directly between sheets. you have to create a named range, the same as you would with Data Validation
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 01-18-2013, 11:57 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Conditional Formatting with INDEX/MATCH

    I have just been informed that 2010 has enhanced capability to reference CF across sheets (thanks Jeff)
    Reply With QuoteRegister To Reply
  5. 01-22-2013, 02:39 PM #5
    Shanster695
    Shanster695 is offline
    Registered User
    Join Date
    01-14-2013
    Location
    Hamilton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditional Formatting with INDEX/MATCH [SOLVED]

    I figured it out...

    Formula: copy to clipboard 
    =IF(COUNTIF(Sheet1!A1,"*TYP*"),(TEXT(Sheet1!A1,"")),(""))


    Thanks for the help guys!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1