danhenshy23
New Member
- Joined
- Oct 3, 2016
- Messages
- 27
Hi,
I have a series of data running across a number of columns. Where a certain word appears in the data, I am wanting to colour fill the 3 cells to the left of it.
Using the below example, where the word Dog appears, I would like the 3 cells to the left of the cell containing the word Dog to be filled in.
Is this possible?
<tbody>
</tbody>
Thanks
Dan
I have a series of data running across a number of columns. Where a certain word appears in the data, I am wanting to colour fill the 3 cells to the left of it.
Using the below example, where the word Dog appears, I would like the 3 cells to the left of the cell containing the word Dog to be filled in.
Is this possible?
A | B | C | D | E | F | G | H | |
1 | text | text | text | Dog | text | text | text | Dog |
2 | text | text | text | Pig | text | text | text | Dog |
3 | text | text | text | Cat | text | text | text | Cat |
4 | text | text | text | Dog | text | text | text | Owl |
<tbody>
</tbody>
Thanks
Dan
Last edited: