Apr 04 2018
06:00 PM
- last edited on
Jul 25 2018
11:34 AM
by
TechCommunityAP
Apr 04 2018
06:00 PM
- last edited on
Jul 25 2018
11:34 AM
by
TechCommunityAP
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
Apr 04 2018 08:12 PM
Hi,
This is possible and can be done by using the Conditional Formatting.
Please follow the below steps:
=VLOOKUP($A2,Sheet2!$A$2:$B$18,2,0)=0
Please find the attached file.
Hope that helps