Compare data in 3 cells

D

dd

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?
 
W

WLMPilot

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)
 
Top