Formula and Functions

[DeeDeeFP]

this is just an example below of what i'm looking for.  I would like to be able to highlight every other circuit along with the rows associated with it.  I tried conditional formatting but i don't know the formula to do this.  Is it possible?  The circuit numbers are always changing, and actual file is very large.

A00100	North	Khan	Assess	ETH1000-2338827
A00101	South	Lopez	Replace	ETH1000-2338827
A00102	Central	Cartier	Deliver	ETH1000-2338827
A00103	South	Lopez	Deliver	ETH1000-2338827
A00104	Northwest	Cartier	Deliver	ETH1000-2338827
A00105	South	Lopez	Assess	ETH1000-2338827
A00106	Central	Cartier	Assess	ETH1000-2338827
A00107	South	Lopez	Replace	ETH1000-2338827
A00108	Northwest	Burton	Deliver	ETH1000-2336622
A00109	Central	Khan	Repair	ETH1000-2336622
A00110	West	Burton	Replace	ETH1000-2336622
A00111	South	Lopez	Deliver	ETH1000-2336622
A00112	West	Burton	Assess	TH2000-23334456
A00113	Central	Michner	Assess	TH2000-23334456
A00114	Northwest	Khan	Replace	TH2000-23334456
A00115	South	Lopez	Assess	TH2000-23334456
A00116	West	Burton	Assess	TH2000-23334456
A00117	Northwest	Burton	Assess	ETH1000-9987779
A00118	Northwest	Cartier	Replace	ETH1000-9987779
A00119	Southeast	Khan	Replace	ETH1000-9987779
A00120	Central	Cartier	Repair	ETH1000-9987779
A00121	Southeast	Khan	Replace	ETH1000-9987779
A00122	Northwest	Khan	Assess	ETH1000-9987779
A00123	South	Lopez	Replace	ETH1000-9987779
A00124	Northwest	Michner	Replace	ETH1000-9987779
A00125	South	Lopez	Assess	ETH1000-5558378
A00126	Northwest	Burton	Deliver	ETH1000-5558378
A00127	South	Lopez	Deliver	ETH1000-5558378
A00128	West	Khan	Assess	ETH1000-5558378
A00129	Northwest	Michner	Deliver	ETH1000-5558378
A00130	Southwest	Cartier	Replace	ETH1000-5558378
A00131	Northwest	Khan	Assess	ETH1000-5558378
A00132	Northwest	Khan	Replace	ETH1000-4433443
A00133	West	Khan	Assess	ETH1000-4433443
A00134	West	Khan	Replace	ETH1000-4433443
A00135	Northwest	Khan	Assess	ETH1000-4433443
A00136	West	Khan	Replace	ETH1000-4433443
A00137	Southeast	Cartier	Assess	ETH1000-4433443
A00138	Northwest	Michner	Deliver	ETH1000-4433443
A00139	South	Lopez	Assess	ETH1000-4433443
A00140	Northwest	Michner	Replace	ETH1000-4433443
A00141	West	Khan	Replace	ETH1000-4433443
A00142	Northwest	Khan	Assess	ETH1000-4433443
A00143	Northwest	Burton	Assess	ETH1000-4433443

[#2]

@DeeDeeFP 

Is the attached example similar to what you are looking for?

[#3]

i'm looking for a formula to highlight all the rows associated with the same circuit #, then not highlight the next group,, then highlight the next. Everyother group of rows associated with the same circuit. Not sure if that's possible?

[#4]

@DeeDeeFP 

Maybe like in the attached file. The values from column E are copied in column H. Then duplicates are removed with Data -> Remove Duplicates.

Every other # is then selected in column I with this formula:

=IF(MOD(ROW(),2)=1,H1,"")

This is the rule for conditional formatting which compares the values in column E with the values in column I:

=ISNUMBER(MATCH($E1,$I$1:$I$6,0))

[#5]

@DeeDeeFP 

A different take on what it is that you might be looking for?