If you change the Target column to just the percentages, you could use VLOOKUP to get the target shrinkage for the brand and compare that to the actual shrinkage. You'll need two CF formulae; one for red and one for green. Or, you could default to green and just CF red.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.