One thing which might cause problems is if what you think are identical
contents in the 2 columns are not actually identical. You may, for example
be confused if one or other of the columns has spare spaces or other
non-printing characters.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Mike's formula works fine. Perhaps you'd better read the instructions
again?
--
David Biddulph

"dardiaca" wrote in message
...
Sorry Mike, but this is not working.

Let's assume I have my entire population in Colum A.
a
b
c
c
e

In column B I have those who attended the course
b
c
e

How do I create a new column C or highlight in column A those who didn't
attend the course?
Thx again

"Mike H" wrote:

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