A cell value is"MEDIUM & LARGE" or "LARGE & MEDIUM".Iwould like apply
conditional format for these two words two different colors,that means MEDIUM
word should have one color and LARGE word should have other color."&" string
with common color.Any give a Vb code