From the list below:
Start Date,End Date,Names
12/10,15/10,Kevin
14/10,16/10,Jason
14/10,20/10,Kevin
I manage to highlight the name if the occurrence is more than once.
=COUNTIFS($A$2:$A2,$A2,$CF$2:$C2,$C2)>1
I need to create a conditional formatting to highlight second occurrence of Kevin's name if the new Start Date entered falls between two existing dates for the first occurrence.
Could someone please help with the formula?
Start Date,End Date,Names
12/10,15/10,Kevin
14/10,16/10,Jason
14/10,20/10,Kevin
I manage to highlight the name if the occurrence is more than once.
=COUNTIFS($A$2:$A2,$A2,$CF$2:$C2,$C2)>1
I need to create a conditional formatting to highlight second occurrence of Kevin's name if the new Start Date entered falls between two existing dates for the first occurrence.
Could someone please help with the formula?