Results 1 to 4 of 4

conditional format based whether VLOOKUP finds a value

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    62

    conditional format based whether VLOOKUP finds a value

    Is there any way to turn a cell a specific color if a index/match formula finds a value but leave no color in the target cell if it does not? My formula looks at at inventory levels of parts off another sheet with a specific date. If the date does not match, the cell returns the previous days inventory level. I need the cell to format to green if the inventory is a direct result of the index/match. Here is my formula: =IF(BN5=Inventory!$B$1,IFERROR(VLOOKUP($C7,Inventory!$A$3:$B$200,2,FALSE),0),BM10). Right now I have to color each of 125 cells manually and it is very time consuming.
    Last edited by merlyn45; 05-14-2012 at 02:41 PM.

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