Forum Discussion

excicuter's avatar
excicuter
Copper Contributor
May 01, 2018

Need help in formula

Hello,

         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.  

Excel Desktop
Formulas & Functions
  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor
    May 02, 2018

    Hi,

     

    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?

Resources