Forum Discussion
Inventory tracker
I was wondering if anyone could help me come up with a formula for the following.
I have a spreadsheet that has each vehicle in my fleet. It has mileages, dates and part number.
Is it pos...
Hi,
This is possible and can be done by using the Conditional Formatting.
Please follow the below steps:
- Select the part numbers' range in Sheet1
- Go to Home >> Styles >> Conditional Formatting >> New Rule >> Use a formula...
- Put this formula in the formula box, but this is with assuming that the range in which the inventory count is from B2:B18 of the Sheet2 and the part numbers is from A2:A18.
=VLOOKUP($A2,Sheet2!$A$2:$B$18,2,0)=0
- Click Format button to choose the format that you want, and then hit OKs.
Please find the attached file.
Hope that helps
thanks haytham!
