View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lindsey lindsey is offline
external usenet poster
 
Posts: 43
Default Deleting Non-Highlighted Cells

I have a conditional formula set up to highlight cels that are the only
occurance or are the first occurance of a duplicate. So, all of the
duplicates are not highlighted. How do I delete all of the non-highlighted
cells? Thank you.