Condiitonal formatting-colored cell
 

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?

Condiitonal formatting-colored cell
 

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?

Condiitonal formatting-colored cell
 

Sorry, but I am not understanding your formula.
All I want to do is go in the Format/conditional formatting, and findout
what formula I should put in there to:
I have a row (merged cells) where I need to write text. I want the row to
turn yellow if I start the text with an asterix*. If there is no asterix*,
then it can stay no fill.
Thanks.

"Peo Sjoblom" wrote:

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?

Condiitonal formatting-colored cell
 

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?

Condiitonal formatting-colored cell
 

What I put there is exactly what you are going to put there after you select
formula is
then click the format button and select a yellow pattern. Replace A2 in the
formula with the cell you want to use


--


Regards,


Peo Sjoblom


"Diane" wrote in message
...
Sorry, but I am not understanding your formula.
All I want to do is go in the Format/conditional formatting, and findout
what formula I should put in there to:
I have a row (merged cells) where I need to write text. I want the row to
turn yellow if I start the text with an asterix*. If there is no asterix*,
then it can stay no fill.
Thanks.

"Peo Sjoblom" wrote:

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?

Condiitonal formatting-colored cell
 

Sorry, I misunderstood. I thought you were looking to find the words
"if there is no"

Use

=TRIM(LEFT(A2))="*"


--


Regards,


Peo Sjoblom



"Peo Sjoblom" wrote in message
...
What I put there is exactly what you are going to put there after you
select formula is
then click the format button and select a yellow pattern. Replace A2 in
the formula with the cell you want to use


--


Regards,


Peo Sjoblom


"Diane" wrote in message
...
Sorry, but I am not understanding your formula.
All I want to do is go in the Format/conditional formatting, and findout
what formula I should put in there to:
I have a row (merged cells) where I need to write text. I want the row to
turn yellow if I start the text with an asterix*. If there is no
asterix*,
then it can stay no fill.
Thanks.

"Peo Sjoblom" wrote:

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?

Condiitonal formatting-colored cell
 

Thanks works perfectly!

"John Bundy" wrote:

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?