Good day! I have dataset that looks like this (let's assume that "Name" is column A and "Sequence" is column B):
<tbody>
</tbody>
I am in the need of a simple formula highlights the 4 "Sequence" cells in red when the sequence for each "Name" is any different from the two following sequences: "1 ,2, 3, 4" or "1, 2, 3, -": in the given example, DOG should turn red since the sequence is different from the two allowed ones.
Thanks in advance,
Alejandro
Name | Sequence |
BUNNY | 1 |
BUNNY | 2 |
BUNNY | 3 |
BUNNY | 4 |
TIGER | 1 |
TIGER | 2 |
TIGER | 3 |
TIGER | - |
DOG | 4 |
DOG | 3 |
DOG | 1 |
DOG | 2 |
<tbody>
</tbody>
I am in the need of a simple formula highlights the 4 "Sequence" cells in red when the sequence for each "Name" is any different from the two following sequences: "1 ,2, 3, 4" or "1, 2, 3, -": in the given example, DOG should turn red since the sequence is different from the two allowed ones.
Thanks in advance,
Alejandro