View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Karen is offline
external usenet poster
 
Posts: 447
Default 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