Excel conditional format using countif

Hi,

I've used

Please Login or Register  to view this content.

To get a true / false for duplicates, but when I've used the same in conditional formatting it is not giving the correct results;

I've trie as a range

Please Login or Register  to view this content.

I've attached an example, if some one can see why the true / false is not working in the condition?

I don't know if I've got the absoluting wrong.


Richard

How about

Formula:

Please Login or Register  to view this content.

Yes, thanks to both of you.

Richard.

Glad to help & thanks for the feedback.