| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
* causing problems with finding duplicates with conditional format
I'm using conditional formatting to highlight duplicates in EXCEL 2007. The
column I need to locate duplicates in has '*' in it. As a result it is considering the following to be duplicates. 2284Hill*9 2284Hill*89 Is there any way to tell EXCEL not to interpret the * as a universal character in either 'COUNTIF' or conditional formating OR in a Find/Replace so I can change it to something else? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Watermark Causing Print Problems | Excel Discussion (Misc queries) | |||
| my personal.xls file is causing problems | Excel Discussion (Misc queries) | |||
| Rand () causing Problems. | Excel Discussion (Misc queries) | |||
| conditional format for duplicates | Excel Worksheet Functions | |||
| Is Excel causing me system problems? | Excel Discussion (Misc queries) | |||
Threaded Mode
