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)




"dd" wrote:

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?