Use formula is

=ISNUMBER(SEARCH("if there is no",A2))


in the example you would change the appearance of A2

I assume you know how to select the format in the pattern tab


--


Regards,


Peo Sjoblom


"Diane" wrote in message
...
I would like a cell to turn yellow if I start a sentence with an *, if
there
is no *, then no color.

How would I phrase this in the conditional formatting option?