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 Formating by word(s)
Hello, I have 2003, I'm trying to color cells that have specific words w/in
the cell. I want to count words like "*broke*" and "broken*" as the same to get the same formating. I need to do this for 6 other words to be formatted in their own unique color. Surprised that I couldn't find any info. in these discussion groups that spoke of my dillema. Thanks much, MC |
#2
|
|||
|
|||
Conditional Formating by word(s)
Use a formula
=ISNUMBER(SEARCH("broke",B19)) where B19 is the start of the selection. HTH Peter "Michaelcip" wrote: Hello, I have 2003, I'm trying to color cells that have specific words w/in the cell. I want to count words like "*broke*" and "broken*" as the same to get the same formating. I need to do this for 6 other words to be formatted in their own unique color. Surprised that I couldn't find any info. in these discussion groups that spoke of my dillema. Thanks much, MC |
#3
|
|||
|
|||
Conditional Formating by word(s)
Thanks much!!!!
"Billy Liddel" wrote: Use a formula =ISNUMBER(SEARCH("broke",B19)) where B19 is the start of the selection. HTH Peter "Michaelcip" wrote: Hello, I have 2003, I'm trying to color cells that have specific words w/in the cell. I want to count words like "*broke*" and "broken*" as the same to get the same formating. I need to do this for 6 other words to be formatted in their own unique color. Surprised that I couldn't find any info. in these discussion groups that spoke of my dillema. Thanks much, MC |
Thread Tools | |
Display Modes | |
|
|