| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting in Excel 2007
I would like a cell to change color if the cell contains one of 2 specific
words (maybe 3 words?). The cell may contain that word alone or that word and addtional words. I only need the formula, I know how to change the cell format. Thanks, -- Glenda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting in Excel 2007
Hi Glenda,
Not sure if this will work in XL2007 but... Set your conditional format to Formula is and enter the formula =OR(A1="word1",A1="word2",A1="word3") Change cell reference and "word" for your own needs. Selct your format. Hope this helps, Gav. "Glenda" wrote: I would like a cell to change color if the cell contains one of 2 specific words (maybe 3 words?). The cell may contain that word alone or that word and addtional words. I only need the formula, I know how to change the cell format. Thanks, -- Glenda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting in Excel 2007
The original question should have included that the word might be one in a
string of words (this is a 'comments' column). Building on your response, I thought =OR(A1="*word1*",A1="*word2*") would work, but obviously I'm putting the wildcard at the wrong place? -- Glenda "Gav123" wrote: Hi Glenda, Not sure if this will work in XL2007 but... Set your conditional format to Formula is and enter the formula =OR(A1="word1",A1="word2",A1="word3") Change cell reference and "word" for your own needs. Selct your format. Hope this helps, Gav. "Glenda" wrote: I would like a cell to change color if the cell contains one of 2 specific words (maybe 3 words?). The cell may contain that word alone or that word and addtional words. I only need the formula, I know how to change the cell format. Thanks, -- Glenda |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting in Excel 2007
Ok you could try setting up 2 conditions for the words you want and try this
in your conditional formatting... CF1 Formula Is .. =SEARCH("*word1*",A1) CF2 Formula Is.... =SEARCH("*word2*",A1) Hope this helps Gav "Glenda" wrote: The original question should have included that the word might be one in a string of words (this is a 'comments' column). Building on your response, I thought =OR(A1="*word1*",A1="*word2*") would work, but obviously I'm putting the wildcard at the wrong place? -- Glenda "Gav123" wrote: Hi Glenda, Not sure if this will work in XL2007 but... Set your conditional format to Formula is and enter the formula =OR(A1="word1",A1="word2",A1="word3") Change cell reference and "word" for your own needs. Selct your format. Hope this helps, Gav. "Glenda" wrote: I would like a cell to change color if the cell contains one of 2 specific words (maybe 3 words?). The cell may contain that word alone or that word and addtional words. I only need the formula, I know how to change the cell format. Thanks, -- Glenda |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting in Excel 2007
Thanks GAV,
-- Glenda "Gav123" wrote: Ok you could try setting up 2 conditions for the words you want and try this in your conditional formatting... CF1 Formula Is .. =SEARCH("*word1*",A1) CF2 Formula Is.... =SEARCH("*word2*",A1) Hope this helps Gav "Glenda" wrote: The original question should have included that the word might be one in a string of words (this is a 'comments' column). Building on your response, I thought =OR(A1="*word1*",A1="*word2*") would work, but obviously I'm putting the wildcard at the wrong place? -- Glenda "Gav123" wrote: Hi Glenda, Not sure if this will work in XL2007 but... Set your conditional format to Formula is and enter the formula =OR(A1="word1",A1="word2",A1="word3") Change cell reference and "word" for your own needs. Selct your format. Hope this helps, Gav. "Glenda" wrote: I would like a cell to change color if the cell contains one of 2 specific words (maybe 3 words?). The cell may contain that word alone or that word and addtional words. I only need the formula, I know how to change the cell format. Thanks, -- Glenda |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting in Excel 2007
thank you again, it works in 2007
-- Glenda "Gav123" wrote: Ok you could try setting up 2 conditions for the words you want and try this in your conditional formatting... CF1 Formula Is .. =SEARCH("*word1*",A1) CF2 Formula Is.... =SEARCH("*word2*",A1) Hope this helps Gav "Glenda" wrote: The original question should have included that the word might be one in a string of words (this is a 'comments' column). Building on your response, I thought =OR(A1="*word1*",A1="*word2*") would work, but obviously I'm putting the wildcard at the wrong place? -- Glenda "Gav123" wrote: Hi Glenda, Not sure if this will work in XL2007 but... Set your conditional format to Formula is and enter the formula =OR(A1="word1",A1="word2",A1="word3") Change cell reference and "word" for your own needs. Selct your format. Hope this helps, Gav. "Glenda" wrote: I would like a cell to change color if the cell contains one of 2 specific words (maybe 3 words?). The cell may contain that word alone or that word and addtional words. I only need the formula, I know how to change the cell format. Thanks, -- Glenda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting In Excel 2007 | Excel Discussion (Misc queries) | |||
| Using conditional formatting in Excel 2007 | New Users to Excel | |||
| Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
| Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
