I've tried just about everything I can think of, but I must be missing something.
I need to conditionally format a cell to turn green if three different quantities hit a minimum number, and one of those quantities hits a secondary and/or tertiary target.
Pants minimum = 6
Shirts minimum = 12
Coats minimum = 3
Pants = 12
Shirts = 24
Coats = 6
Pants = 18
Shirts = 36
Coats = 12
So double shirt cell should only turn green if a single target is accomplished on all three items, and the second level for that shirt target is also reached.
I currently have it laid out as followsCaptureddgd.JPG
I need only the cells to highlight if those numbers have been hit, and only if they hit a minimum of a single in all three items. So ideally the first three under single should turn green with the And formula which i have nailed down, however I can't get the double or the triple cells to work.