With conditional formatting

In the top name of your entire population enter the conditional format

Formula is =COUNTIF(B$1:B$1000,A1)=0 and add a colour

Use format painter to paint format into all cells on that list.

Any names not in the list B1 to B1000 will be highlighted.

Mike



"dardiaca" wrote:

I have two lists: one with my entire population and the second with the ones
that subscribed a training course. Which function should I use to compare
both lists and highlight in a new column those who still need training?
Thanks