With example in A7
=LEFT(A7,1)="*"

if you leave the $ that it puts by default it will mess you up.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Diane" wrote:

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?