Hello,

How to highlight the last cell in column of similar values in column having different sets of values

<tbody>

</tbody>

So we have to highlight B3,B6 and B7.

Thanks

How to highlight the last cell in column of similar values in column having different sets of values

A | B | C | |

1 | apple | ||

2 | apple | ||

3 | orange | ||

4 | lemon | ||

5 | lemon | ||

6 | lemon | ||

7 | apple | ||

8 | |||

<tbody>

</tbody>

So we have to highlight B3,B6 and B7.

Thanks

Last edited: