| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS
I have a spreadsheet of dialled telephone number in various formats eg
"01234123456", or "00441234123456", and am trying to highlight their personal calls using conditional formatting. I am looking for a formula that says highlight this cell if this cell CONTAINS "123456" ie that last six digits of the number. Some people do however use a * at the end of the number dialled to indicate a personal call but they are not consistent! e.g 01234123456* or 00441234123456* Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating with TEXT | Excel Discussion (Misc queries) | |||
| conditional formating colours to stay when numbers are deleted? | Excel Worksheet Functions | |||
| conditional formatting on specific text in cells | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
Threaded Mode
