Condiitonal formatting-colored cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diane - 07 May 2008 16:42 GMT

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?

Reply to this Message

Peo Sjoblom - 07 May 2008 17:04 GMT

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

Signature

Regards,

Peo Sjoblom

>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?

Reply to this Message

Diane - 07 May 2008 17:16 GMT

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.

> Use formula is
>
[quoted text clipped - 9 lines]
> >
> > How would I phrase this in the conditional formatting option?

Reply to this Message

Peo Sjoblom - 07 May 2008 17:21 GMT

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

Signature

Regards,

Peo Sjoblom

> Sorry, but I am not understanding your formula.
> All I want to do is go in the Format/conditional formatting, and findout
[quoted text clipped - 17 lines]
>> >
>> > How would I phrase this in the conditional formatting option?

Reply to this Message

Peo Sjoblom - 07 May 2008 17:24 GMT

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

Use

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

Signature

Regards,

Peo Sjoblom

> What I put there is exactly what you are going to put there after you
> select formula is
[quoted text clipped - 23 lines]
>>> >
>>> > How would I phrase this in the conditional formatting option?

Reply to this Message

John Bundy - 07 May 2008 17:20 GMT

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

if you leave the $ that it puts by default it will mess you up.

Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> 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?

Reply to this Message

Diane - 07 May 2008 17:26 GMT

Thanks works perfectly!

> With example in A7
> =LEFT(A7,1)="*"
[quoted text clipped - 5 lines]
> >
> > How would I phrase this in the conditional formatting option?

Reply to this Message