Forum Discussion

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...

Bin Card - 2018.xlsx408 KB

May-2018 - Copy.xlsx381 KB

Bin Card - 2018 - Copy.xlsx421 KB

Excel Desktop

Formulas & Functions

Logaraj Sekar

Iron 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?