Inventory tracker

[null null]

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 possible to have a part number turn red if on another sheet i have the inventory count to zero. But if the number stays 1 or more the part number would stay black.

example 

Sheet one: Part # 3626

Sheet two: Part # 3626 0

Thanks

[#2]

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

[#3]

thanks haytham!