ExcelBanter - Compare data in 3 cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Compare data in 3 cells (https://www.excelbanter.com/excel-worksheet-functions/107425-compare-data-3-cells.html)

Compare data in 3 cells

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?

WLMPilot

Compare data in 3 cells

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?

All times are GMT +1. The time now is 05:53 PM.