Results 1 to 6 of 6

Conditional Formatting with Index/Match function

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2011
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    5

    Conditional Formatting with Index/Match function

    Hello,

    I'm struggling with adding conditional formatting to a function that combines index and match

    Here is the function:
    =INDEX('Sheet2'!$C$7:$C$91,MATCH(A12,'Sheet2'!$B$7:$B$91,0))

    So this function returns values when there is a value, but more often than not it returns #N/A when there's no match.

    How do I white-out the #N/A to unclutter how my page looks? I tried to use the "text that contains" option on conditional formatting but nothing happens. Do I need to add some sort of If function (maybe with istext) around the existing function?

    Thank you for the help.
    Last edited by zhopa19; 06-16-2011 at 10:17 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1