| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I conditionally format cells based on part of their text?
I would like to change the format of cells based on part of their text. For
example, cells containing 'Written - New' and 'Written - Renew' should be formatted the using only one condition. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I conditionally format cells based on part of their text?
Hi
Choose "Formula is" in condition1 and use this formula: =Left(A1,7)="Written" and format as desired. Regards, Per "Buz" skrev i meddelelsen ... I would like to change the format of cells based on part of their text. For example, cells containing 'Written - New' and 'Written - Renew' should be formatted the using only one condition. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I conditionally format a cell based on the value in a diff | Excel Discussion (Misc queries) | |||
| Can I conditionally format a line based on a cell value | Excel Discussion (Misc queries) | |||
| how can I conditionally format a cell Part 2 | Excel Discussion (Misc queries) | |||
| Conditionally format points based on a third column | Charts and Charting in Excel | |||
| Conditional Format Part of Cells Text | Excel Discussion (Misc queries) | |||
Hybrid Mode
