View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Conditional Formatting to Compare to Lists

I have two lists of names. In the second list, I'd like highlight all
of the names that are new to the list. In the first list, I'd like to
highight all of the names on the first list but not the second.

Could this be done using conditional formatting without adding any
dummy or helper columns?

Thanks.

- John