0
I'm trying to create a conditional format across an entire range that would check on the product's availability status. So far I could get it to work using
=(vlookup(A3, F2:G15, 2, False) = "Out of Stock")
But it's only working for the referenced cell, which in this case is A3. Is there a way to set it up so the conditional format checks the cell it is formatting?
Docs: https://docs.google.com/spreadsheets/d/1L3NSxalwBHYOsqfZfspLfxUlixyPMq9h2SyZ6GdZLpo/edit?usp=sharing