Conditional Formatting Text!!

[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

 

[Beege]

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

 

[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

 

[Guest]

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

 

[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

 

[Kiran]

Hi

Thank you for this suggestion - fantastic!!!

It works a treat

Regards

Kiran

 

[Kiran]

Thanks for all your suggestions!!

Regards

 

[Pete_UK]

Thanks for feeding back, Kiran.

Pete