Conditional Formatting to Compare to Lists

  • Thread starter Thread starter John Michl
  • Start date Start date
J

John Michl

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
 
Conditional formattion with formula.
Say first list is in A1:A1000, Second list in B1:B500

Second list formula:
=COUNTIF(A1:A1000,B1)=0

First list formula:
=COUNTIF(B1:B500,A1)=0

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XL2000 CF and Comparing Lists 5
Conditional Highlight 16
Conditional Formatting with Partial name search 2
Excel Comparing two columns 1
Conditional Formating 2
XL2000, CF and List Comparisons 3
Conditional Formatting - Comparative Versus Other Cells 4
Conditional formatting based on max in range of other columns 2

Back
Top