| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format when text contains using cell reference
Hi All,
I'm trying to format a cell based on the text content of another cell. The part I'm having problems with is that the referenced cell will "contain" a certain phrase I'm looking for. Any ideas? Thanks. Cheryl |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format when text contains using cell reference
Depending on how flexible you need the 'Contains' to be, you can go to
conditional format, select formula is and enter something like: =FIND("dog",$B$1), if "dog" is found anywhere within it will turn red. (after you set it to turn red of course) -- -John Please rate when your question is answered to help us and others know what is helpful. "Cheryl" wrote: Hi All, I'm trying to format a cell based on the text content of another cell. The part I'm having problems with is that the referenced cell will "contain" a certain phrase I'm looking for. Any ideas? Thanks. Cheryl |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format when text contains using cell reference
John,
That worked like a charm! Thank you! :) Cheryl "John Bundy" wrote: Depending on how flexible you need the 'Contains' to be, you can go to conditional format, select formula is and enter something like: =FIND("dog",$B$1), if "dog" is found anywhere within it will turn red. (after you set it to turn red of course) -- -John Please rate when your question is answered to help us and others know what is helpful. "Cheryl" wrote: Hi All, I'm trying to format a cell based on the text content of another cell. The part I'm having problems with is that the referenced cell will "contain" a certain phrase I'm looking for. Any ideas? Thanks. Cheryl |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format when text contains using cell reference
Cheryl wrote:
Hi All, I'm trying to format a cell based on the text content of another cell. The part I'm having problems with is that the referenced cell will "contain" a certain phrase I'm looking for. Any ideas? Thanks. Cheryl Look at the FIND worksheet function. =FIND("a certain phrase",referenced_cell) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional format when text contains using cell reference
Thanks Glenn. :)
Cheryl "Glenn" wrote: Cheryl wrote: Hi All, I'm trying to format a cell based on the text content of another cell. The part I'm having problems with is that the referenced cell will "contain" a certain phrase I'm looking for. Any ideas? Thanks. Cheryl Look at the FIND worksheet function. =FIND("a certain phrase",referenced_cell) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining text and cell reference keeping number format | Excel Discussion (Misc queries) | |||
| conditional format if cell contains the text IQ anywhere in cell | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| Format cell conditional numeric and text | Excel Discussion (Misc queries) | |||
Hybrid Mode
