Forum Discussion

null null's avatar
null null
Copper Contributor
Apr 04, 2018

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

Formulas & Functions
Need Help

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 04, 2018

    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

Resources