conditional formatting help please

greetings......i have a row in which if say a4 contains the word help,
then all that row is in red text, othewise it is in black text

a1 a2 a3 a4 a4
dept author title help low


so that if a4 says help..... help me or help now etc....... the whole
row is red


thanks in advance
K

Hello

1. Select row 4 and choose Format Conditional formatting
2. Choose "Formula is" and enter this formula:
=SEARCH("help",$A$4)
It's imperative that A4 is absolute (contain $$). If not, it will
change through the row: A4, B4, C4 etc.
3. Choose red text. OK. OK.

Now, if A1 contains the word "help" (among other words or
alone), row 4 will contain red text.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"*k*" skrev i en meddelelse
...
greetings......i have a row in which if say a4 contains the word help,
then all that row is in red text, othewise it is in black text

a1 a2 a3 a4 a4
dept author title help low


so that if a4 says help..... help me or help now etc....... the whole
row is red


thanks in advance
K

what do you want to appear in red? just the word help when it stands alone/
--
vpowers
'Thought I was a Pro?"


"*k*" wrote:

greetings......i have a row in which if say a4 contains the word help,
then all that row is in red text, othewise it is in black text

a1 a2 a3 a4 a4
dept author title help low


so that if a4 says help..... help me or help now etc....... the whole
row is red


thanks in advance
K

Hi Karen,
I have a page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If instead of just row 4 with Help in column A, you wanted
to highlight all rows that had Help in Column A, you would
Select all cells before entering the formula, then with A1 as
the active cell:
format, cells, Conditional Format
formula is: =$A1="help"
then format the font Red from the big format button.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"*k*" wrote in message ...
greetings......i have a row in which if say a4 contains the word help,
then all that row is in red text, othewise it is in black text

a1 a2 a3 a4 a4
dept author title help low


so that if a4 says help..... help me or help now etc....... the whole
row is red


thanks in advance
K

Hi,

Select your data
Format Conditional Formatting Formula Is
=SEARCH("help",$A1)
Choose your formatting
Click Ok

Hope this helps!


---
Message posted from http://www.ExcelForum.com/

easy when ya know how....thanks for that :-)

On Fri, 18 Jun 2004 06:55:58 +0200, "Leo Heuser"
wrote:

Hello

1. Select row 4 and choose Format Conditional formatting
2. Choose "Formula is" and enter this formula:
=SEARCH("help",$A$4)
It's imperative that A4 is absolute (contain $$). If not, it will
change through the row: A4, B4, C4 etc.
3. Choose red text. OK. OK.

Now, if A1 contains the word "help" (among other words or
alone), row 4 will contain red text.

sorry no....the a1 to a5

On Thu, 17 Jun 2004 22:28:01 -0700, "vpowers"
wrote:

what do you want to appear in red? just the word help when it stands alone/

Hi Davis, sorry I did have a look at your excellent site...but didnt
see what I was after.....obviously not looking to closely was
I.....thanks for that :-)

On Fri, 18 Jun 2004 02:24:55 -0400, "David McRitchie"
wrote:

Hi Karen,
I have a page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If instead of just row 4 with Help in column A, you wanted
to highlight all rows that had Help in Column A, you would
Select all cells before entering the formula, then with A1 as
the active cell:
format, cells, Conditional Format
formula is: =$A1="help"
then format the font Red from the big format button.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"*k*" wrote in message ...
greetings......i have a row in which if say a4 contains the word help,
then all that row is in red text, othewise it is in black text

a1 a2 a3 a4 a4
dept author title help low


so that if a4 says help..... help me or help now etc....... the whole
row is red


thanks in advance
K

sure does..... thanks for that :-) much appreciated


On Fri, 18 Jun 2004 07:38:29 -0500, Domenic
wrote:

Hi,

Select your data
Format Conditional Formatting Formula Is
=SEARCH("help",$A1)
Choose your formatting
Click Ok

Hope this helps!


---
Message posted from http://www.ExcelForum.com/

You're welcome. Thanks for the feedback :-)

LeoH


"*k*" skrev i en meddelelse
...
easy when ya know how....thanks for that :-)

On Fri, 18 Jun 2004 06:55:58 +0200, "Leo Heuser"
wrote:

Hello

1. Select row 4 and choose Format Conditional formatting
2. Choose "Formula is" and enter this formula:
=SEARCH("help",$A$4)
It's imperative that A4 is absolute (contain $$). If not, it will
change through the row: A4, B4, C4 etc.
3. Choose red text. OK. OK.

Now, if A1 contains the word "help" (among other words or
alone), row 4 will contain red text.