find duplicates

[RandyD123]

I have a sheet that can be seen here. I'm not sure how I got the UID column to fill in automatically when I type something in the Name and Date column but it doesn't seem to work for the COUNT column. I'm trying to get duplicate rows to highlight automatically but I cant figure out how to apply the conditional formatting. Do I need the UID and the COUNT column?

Any help would be appreciated. Thank You

 

[mole999]

from 2007 click the column letter (select the column), then click conditional formatting, Highlight Cell Rules > Duplicate values

 

[RandyD123]

from 2007 click the column letter (select the column), then click conditional formatting, Highlight Cell Rules > Duplicate values

That won't work, as you can see the same name can appear more than once. It's when the NAME & DATE both match I need to highlight the duplicate row ONLY

 

[mole999]

so concatenate the two cells with =A1&B1 (appropriate adjustment) then do the duplicate on that value

 

[RandyD123]

I've done that, that is my UID column. Not sure how to write the conditional format code to just highlight the duplicate row only

 

[mole999]

do you actually need to highlight the entire row, i find just the one identified is enough to work from. you only need to apply the cf to the uid then

 

[RandyD123]

yes the UID column will be hidden. so i do need the entire row to be highlighted.

 

[Fluff]

Select A3:F29 & use this formula
=COUNTIFS(Name,$A3,DATE,$B3)>1