Format|conditional formatting doesn't work that way. It's the whole cell that
gets formatted.



TUNGANA KURMA RAJU wrote:

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

--

Dave Peterson