| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format cells based on text string contains
On further analysis- I can't figure out how to get it to do it for where the
flag is anywhere in a text string in the cell. e.g. "1st" in a cell which say something like "23 1st Quartile" I tried copy pasting and using variations on the ISNUMBER(SEARCH( combo which I use for conditional formatting but it doesn't like it. I am hoping to use a Macro to paste this Macro in to a new sheet, but it's not looking so great on that front either. Allan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format text string | Excel Discussion (Misc queries) | |||
| Create a 'text' string based on whether values appear in other cel | Excel Worksheet Functions | |||
| Averaging Columns based on a Text String | New Users to Excel | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| Converting text string to a its proper time format | Excel Discussion (Misc queries) | |||
Threaded Mode
