Highlighting row based on different fields and rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.