I want to highlight the rows based on the cells value of a column like below, please advise:

```
aa --> yellow
aa --> yellow
bb --> green
bb --> green
cc --> yellow
cc --> yellow
dd --> green
dd --> green
ee --> yellow
ee --> yellow
ee --> yellow
kk --> green
kk --> green
kk --> green
kk --> green
kk --> green

```

... so on the duplicated groups