Conditional Formatting Text!!

K

Kiran

Hi

I want to conditionally format some text in a spreadsheet using
formula:

I have column A1 with:
4a Be
3a To
4c To
4b Be
4c Be
5c Be
5c To
6a Be

etc...

What I want to do is for all cells which contain "5a Be" "5b Be" 5c
Be" "4a Be" "4b be" and "4c Be" to be highlighted in Red - is there a
formula to put all of them into one formula - If("5a Be" or "5b Be)
etc..

Thanks

Kiran
 
B

Beege

Kiran said:
Hi

I want to conditionally format some text in a spreadsheet using
formula:

I have column A1 with:
4a Be
3a To
4c To
4b Be
4c Be
5c Be
5c To
6a Be

etc...

What I want to do is for all cells which contain "5a Be" "5b Be" 5c
Be" "4a Be" "4b be" and "4c Be" to be highlighted in Red - is there a
formula to put all of them into one formula - If("5a Be" or "5b Be)
etc..

Thanks

Kiran

Format/Conditional Formatting
=A1=OR()

Fill in parentheses as needed, format as you like.

Beege
 
P

Pete_UK

Assuming your data starts in A1, then your formula would be:

=OR(A1="5a Be",A1="5b Be",A1="5cBe",A1="4a Be",A1="4b Be",A1="4c Be")

You can either enter this formula with just A1 selected and then apply
the Format Painter, or highlight all the cells starting with A1 and put
the formula in - it will automatically adjust.

Hope this helps.

Pete
 
R

Ron Coderre

Try something like this:

Select the cells to be formatted
(I selected A1:A10, with A1 as the active cell)

<Format><Conditional Formatting>
Formula is: =ISNUMBER(SEARCH("_"&A1&"_","_5a Be_5b Be_5c Be_4a Be_4b be_4c
Be_"))
Then set the format.

Note: that formula is NOT case sensitive. If you need it to be case
sensitive, replace SEARCH with FIND.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
K

Kiran

Hi

It doesn't seem to work...

I have all my data in column A: with data going from row 1 to 28 etc.

can you give me an example - is this correct:

=A1:A28="4a Be"=OR("4b Be")=OR("etc")
This does not work for me - am I on the right lines?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top