| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells when containing specified text
I am trying to "conditionally format" cells different colors when they
contain certain words (e.g., if text contains 'dog' then cell color is yellow; if text contains 'cat' then cell color is red). I am not looking for EXACT text match before condition formatting is applied. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cells when containing specified text
One way:
Set the dropdowns and textboxes to read CF1: Formula is =COUNTIF(A1,"*dog*") Format1: <patterns/<yellow CF2: Formula is =COUNTIF(A1,"*cat*") Format2: <patterns/<red In article , dinocm wrote: I am trying to "conditionally format" cells different colors when they contain certain words (e.g., if text contains 'dog' then cell color is yellow; if text contains 'cat' then cell color is red). I am not looking for EXACT text match before condition formatting is applied. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Why will my cells not format? | New Users to Excel | |||
| converting general cells format to text | Excel Discussion (Misc queries) | |||
| stopping pasted text deliminate across multiple cells | Excel Discussion (Misc queries) | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
Linear Mode
