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

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

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