Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditonal Formating Excel 2007 - Duplicate Values
I am using the Duplicate values identifier of conditional formating in Excel
2007. I want to highlite cells if 16 characters number (text Format) appears more than once. The function works well for first 15 characters but doesn't differentiate the last characters. As example: conditional formating sees this text format number "6001573308858004" to be a duplicate of "6001573308858008" although last characterer is different. Though, it sees the difference between "6001573308858004" and "6001573308858014". I suspect that function checks only first 15 characters. Can somebody confirm? -- Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Duplicate files in Excel 2007 | Excel Worksheet Functions | |||
Conditional Formating in Excel 2007 | Excel Worksheet Functions | |||
Office 2007-Source formating lost when emailing from excel | Excel Discussion (Misc queries) | |||
Office 2007-Source formating lost when emailing from excel | Excel Discussion (Misc queries) | |||
How to create icon sets for excel 2007 conditionnal formating ? | Excel Discussion (Misc queries) |