- last edited on
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.
Sheet one: Part # 3626
Sheet two: Part # 3626 0
Hi, This is possible and can be done by using the Conditional Formatting. Please follow the below steps:
Please find the attached file.
Hope that helps