Quote Originally Posted by DBY View Post
Hello
You could perhaps use two CF formulas. For example if your range of values was in C2:E20:

=COUNTIF($C$2:$C2,$C2)=1
would highlight selection were the name first occurs. The second applied only to C2:C20:

=COUNTIF($C$2:$C2,$C2)>1
would hide the duplicate values. With both you would obviously have to choose the formats you require. Grey fill, white font etc.

Hope this helps.
DBY

Thanks DBY! I am almost there, but there is a remaining problem:

I formatted the column to have "No" background and White fonts.
I then applied the first suggestions and set =COUNTIF($C$17:$C17,$C18)=1 to apply to all values in the column.
This sets the first instance of the name to have grey background and black fonts which is what I wanted.

However the formula it also hides the names that occur only once. I don't want that!
They should have the same formatting as the other headers, even if they only occur once.

I can't figure out how to prevent that, or construct a Conditional format that sets these names back to the formatting I want.