View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rana Usman Khan
 
Posts: n/a
Default how can i highlight dupplicated in 2 sheets at a time?

i wrote some files number in sheet1 and next month i wrote some files number
again in sheet2 now i want to find dupplicates file numbers in both sheets
and i want to highlight those files. can you please help me. it will be great
help for me. thanks a lot in advance.