| Home |
| Search |
| Today's Posts |
|
#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) |
| 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) | |||
Threaded Mode
