Conditional Formatting Query (Formula)

[Arts]

Hi all

I seem to be having a conditional formatting (formula) issue.

What I need is to highlight the area where there is a duplicate in names but highlight the whole data set

I went with the below formula but this seems to not apply the formatting (assuming I am using the wrong formula?)

Name	Department	Region
Rob	Research	NA
Fred	Funding	SA
Simon	Funding	Europe
Fred	Sciences	Europe

I didn't go with the option to highlight duplicate data within the conditional formatting issue as this then highlights "Funding" where the duplicate driver needs to be the name so the rows containing Fred would be highlighted.

Any help on this would as always be mostly appreciated.

Thanks

 

[Fluff]

You need to change the 2nd $C$3 to $C3

 

[Arts]

D

You need to change the 2nd $C$3 to $C3

Dammit severe rookie mistake! I went over this 50 times and couldn't work it out for the life for me!!

Happy for this post to be deleted to save me a bit of face!

Thanks Fluff!

 

[Fluff]

Glad to help & thanks for the feedback.