Compare data in 3 cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to compare the data in 3 cells. I want the data that doesn't
match to be highlighted. How do I do this?
 
Do a Conditional Format. Use the Formula Is (vs Cell Value Is) option in the
conditional format:

Example: A1 = 3 B1 = 3 C1 = 1 Conditional Format for:

Cell A1: =AND(A1<>B1, A1<>C1)
Cell B1: =AND(B1<>A1, B1<>C1)
Cell C1: =AND(C1<>A1, C1<>B1)
 
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

Comparison of columns using Conditional Formatting 3
Excel Highlighting duplicates 0
matching columns to find differences. 0
Compare data in two worksheets 1
Formula that compares data in adjoining cells 3
Comparing 2 worksheets in Excel 2007 1
Compare 1 cell to column of cells returning adjacent cells info? 1
Compare data in 2 workbooks and highlight differences in red 4

Back
Top