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.
Solved! Go to Solution.
Hey thank you for this!
If i created a new column "field 4" and wanted to auto-populated the row -that is now highlighted- with the value that it is ranked 1 for that field 1 +field 2 combo, how would I go about it?
Thanks in advanced.