| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use conditional formating to find one word in a column. | Excel Discussion (Misc queries) | |||
| Formating from Word to Excel | Excel Discussion (Misc queries) | |||
| Word Formating & Words Adding | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Help with date formating when export to Word | Excel Discussion (Misc queries) | |||
Linear Mode
