Hello,
I'm trying to highlight specific rows if value in "field 3" does not match with the rest of the columns that have the same values in "field 1" and "field 2". For example this is what my output looks like right now:
| field 1 | field 2 | field 3 |
| aa | a | 1 |
| aa | a | 1 |
| aa | a | 1 |
| aa | a | 1 |
| aa | a | 2 |
| ab | a | 3 |
| ab | a | 3 |
| ab | a | 3 |
| ab | a | 3 |
| ab | a | 2 |
| ab | a | 4 |
| ba | b | 1 |
| ba | b | 1 |
| ba | b | 1 |
| ba | b | 1 |
| ba | b | 2.5 |
I want my output to have the rows with red to be highlighted:
| field 1 | field 2 | field 3 |
| aa | a | 1 |
| aa | a | 1 |
| aa | a | 1 |
| aa | a | 1 |
| aa | a | 2 |
| ab | a | 3 |
| ab | a | 3 |
| ab | a | 3 |
| ab | a | 3 |
| ab | a | 2 |
| ab | a | 4 |
| ba | b | 1 |
| ba | b | 1 |
| ba | b | 1 |
| ba | b | 1 |
| ba | b | 2.5 |
Basically I want to highlight the rows that are the odd ones out, dependent on field 3 IF field 1 and field 2 are the same.
Let me know if you have any ideas.
Thanks in advance.
