View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike 215 Mike 215 is offline
external usenet poster
 
Posts: 9
Default Highlite Duplicates in 2 Columns (Conditional Formating)

Hi,
I have 2 columns of data.
Both Columns can contain duplicates
How can I find duplicates in both columns.

A B
1 Car Toy
2 Ball Toy
3 Bed Bar
4 Car Toy
5 Ball Bar

A1, B1, A4 & B4 should be hi-lited with Conditional Formating
Thanks for your help.