Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Duplicates
I have worksheet that has around 250 rows with 6 columns. I need to validate
that the data is the same for two rows at a time. How can I highlight any unique data? Example: STR - AD ITEMS 54500000855 01/0003.29 $1.79 02/0003.00 SAP--- AD ITEMS 54500000855 01/0002.99 $1.49 02/0003.00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Duplicates
Hi,
Unique on which fields? -- Thanks, Shane Devenshire "Karen" wrote: I have worksheet that has around 250 rows with 6 columns. I need to validate that the data is the same for two rows at a time. How can I highlight any unique data? Example: STR - AD ITEMS 54500000855 01/0003.29 $1.79 02/0003.00 SAP--- AD ITEMS 54500000855 01/0002.99 $1.49 02/0003.00 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Duplicates
data that is not a duplicate:
Example: STR - AD ITEMS 54500000855 01/0003.29 $1.79 02/0003.00 SAP--- AD ITEMS 54500000855 01/0002.99 $1.49 02/0003.00 (the 3.29 and the 2.99 do not match so it would need to highlighted, but the issue I have is that in the same report I have a different upc # with same price issue, but it would not highlight it as an issue because it would see it as a match.) STR - AD ITEMS 54500000854 01/0003.29 $1.79 02/0003.00 SAP--- AD ITEMS 54500000854 01/0002.99 $1.49 02/0003.00 (The data below would be correct. 3.29, 1.79, 02/0003.00 match) STR - AD ITEMS 54500000853 01/0003.29 $1.79 02/0003.00 SAP--- AD ITEMS 54500000853 01/0003.29 $1.79 02/0003.00 Hope this makes sense. "Karen" wrote: I have worksheet that has around 250 rows with 6 columns. I need to validate that the data is the same for two rows at a time. How can I highlight any unique data? Example: STR - AD ITEMS 54500000855 01/0003.29 $1.79 02/0003.00 SAP--- AD ITEMS 54500000855 01/0002.99 $1.49 02/0003.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting of duplicates in a range | Excel Worksheet Functions | |||
Conditional Formatting for Duplicates | Excel Worksheet Functions | |||
Duplicates in Conditional Formatting | Excel Discussion (Misc queries) | |||
Locate duplicates in a work book by using conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting to find duplicates | Excel Discussion (Misc queries) |