| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Compare data - one cell to multiple cells | Excel Discussion (Misc queries) | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
