I'd like to put a formula in I2 that checks a2:h2 to see if this range of colors conforms to what I need.
The range A2:H2 must contain at least:
1 Red
1 Orange
1 Yellow
3 Blue
1 Violet
1 [Any of the above colors]
If the range conforms to the restrictions, I'd like it to leave a blank cell. If...