May 01 2018
11:14 AM
- last edited on
Jul 25 2018
11:54 AM
by
TechCommunityAP
May 01 2018
11:14 AM
- last edited on
Jul 25 2018
11:54 AM
by
TechCommunityAP
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.
May 02 2018 10:08 AM
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?