D
Dmox
I have two worksheets: Inventory and Status
Status has two columns
A B
Fridge In Stock
Stove Out of Stock
Oven Low Stock
What I would like to do is when sheet2 is modified, "Fridge" for example is
changed from In Stock to Low Stock it searches Sheet1 for the word "Fridge"
and changes the background color to Yellow.
Because "Fridge" can be in any column or row it can't be tied to a specific
cell.
Is there a way to accomplish this through conditional formatting?
Status has two columns
A B
Fridge In Stock
Stove Out of Stock
Oven Low Stock
What I would like to do is when sheet2 is modified, "Fridge" for example is
changed from In Stock to Low Stock it searches Sheet1 for the word "Fridge"
and changes the background color to Yellow.
Because "Fridge" can be in any column or row it can't be tied to a specific
cell.
Is there a way to accomplish this through conditional formatting?