Need help in formula

Copper Contributor


         I need to create a function/formula for conditional formatting. First i need to match a value from first sheet to second sheet row and want to check that, match value column stock is 0 or not for highlight value in first sheet. 


example i have code for product (4-90-1-2) and want to check in second sheet row that this code is available or not. if it is there then match code column row (Available Stock) is zero or not. I am also using vlookup to get data from another workbook.


I am attaching file.  

1 Reply



So if you type any value in "May 2018" Workbook, "Received Items" Sheet, In Column B and If that code is found in the "Bin Card" Workbook, "Items List" Sheet, In Column A, it will be highlighted in Bin Card Sheet. Right?