(complicated formula for me) Whoever wants to help, the details are inside

[chosen]

I have duplicate names in column A in Excel I want to output FALSE on the first set of duplicate names, then TRUE on the next set of duplicate names, then FALSE on the next set of names, and so on. Sometimes there are no duplicate names, however I want when I change any name it changes from FALSE to TRUE or from TRUE to FALSE
Here is an example I made manually
Emely
Ashly
James
Robert
Robert
Robert
Michael
Michael
David
Richard
James
James
I want it as follows
Ashly TRUE
James FALSE
Robert TRUE
Robert TRUE
Robert TRUE
Michael FALSE
Michael FALSE
David TRUE
Richard FALSE
James TRUE
James TRUE

I want these results for conditional formatting
To color each person individually
Thank you very much

 

[Peter_SSs]

@chosen
Please post in English only in this forum per the request on the main forum page.

Otherwise, please use the Questions in Other Languages forum.

 

[chosen]

@chosen
Please post in English only in this forum per the request on the main forum page.

View attachment 84650

Otherwise, please use the Questions in Other Languages forum.

Sorry
I will not do it again

 

[Fluff]

Another option

Fluff.xlsm
	A
1
2	Emely
3	Ashly
4	Jim
5	Robert
6	Robert
7	Robert
8	Michael
9	Michael
10	David
11	Richard
12	James
13	James
14	Pete
15
16
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A16	Expression	=AND(A2<>"",ISEVEN(ROWS(UNIQUE(A$2:A2))))	text	NO