If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
conditional formatting help please
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 |
#3
|
|||
|
|||
conditional formatting help please
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 |
#4
|
|||
|
|||
conditional formatting help please
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 |
#5
|
|||
|
|||
conditional formatting help please
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/ |
#6
|
|||
|
|||
conditional formatting help please
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. |
#7
|
|||
|
|||
conditional formatting help please
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/ |
#8
|
|||
|
|||
conditional formatting help please
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 |
#9
|
|||
|
|||
conditional formatting help please
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/ |
#10
|
|||
|
|||
conditional formatting help please
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. |
|
Thread Tools | |
Display Modes | |
|
|