When I have a Tie and the same number is referenced is there a way to change the color to RED?

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
364
When I have a Tie and the same number is referenced is there a way to change the color to RED?
See below an example we had a tie 2477 sometimes we have multiple ties so wanted to know if I have a tie how can I have the tie number be turned to RED.

Example so If I have three people tied at 2477 then I would want to turn those ties number 2477 turned to RED. Thanks for your help


TEAM EVENT20th PlaceTEAM EVENT20th Place
I GOT ONE
2477​
Ain't Got No Haters
2477​
 

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
364
Still do not have it perfected yet - Here is the excel - My Conditional Format is wrong :(

Need to only turn items in row C4 G4 and K4 to Red it a Dup is found all the way down to Row 120
Helppppppppppppppppppppppppppppppp

Chris-SEC-VEGAS-SWEEPS-S2021-019.xls
ABCDEFGHIJK
1
2
3TEAM EVENT1st PlaceTEAM EVENT2nd PlaceTEAM EVENT3rd Place
4This is How We Roll2724BOWLBASAUR2675Kingpins2646
5- 01 -320$320.00- 02 -316$316.00- 03 -308$308.00
6Team #18$80.00 EachTeam #35$79.00 EachTeam #1$77.00 Each
7
8
9TEAM EVENT4th PlaceTEAM EVENT5th PlaceTEAM EVENT6th Place
10Flash AUTO-Bowlers2636AlcoHolics!!2598Smiling Faces2565
11- 04 -304$304.00- 05 -300$300.00- 06 -296$296.00
12Team #43$76.00 EachTeam #36$75.00 EachTeam #14$74.00 Each
13
14
15TEAM EVENT7th PlaceTEAM EVENT8th PlaceTEAM EVENT9th Place
16BOWLievers2554Action (Less)2543Don't Give A Split2542
17- 07 -292$292.00- 08 -288$288.00- 09 -284$284.00
18Team #39$73.00 EachTeam #33$72.00 EachTeam #31$71.00 Each
19
20
21TEAM EVENT10th PlaceTEAM EVENT11th PlaceTEAM EVENT12th Place
22We're good for 12539BOWL JOBS!!2532MOM & Her COOL Kids2524
23- 10 -280$280.00- 11 -276$276.00- 12 -272$272.00
24Team #10$70.00 EachTeam #41$69.00 EachTeam #17$68.00 Each
25
26
27TEAM EVENT13th PlaceTEAM EVENT14th PlaceTEAM EVENT15th Place
28They All Fall Down2523The Originals & Kathy2520S.O.B2499
29- 13 -268$268.00- 14 -264$264.00- 15 -260$260.00
30Team #30$67.00 EachTeam #7$66.00 EachTeam #21$65.00 Each
31
32
33TEAM EVENT16th PlaceTEAM EVENT17th PlaceTEAM EVENT18th Place
343 Lefts & A Right2495Catalina Pin Mixers!!2493The Avengers2491
35- 16 -256$256.00- 17 -252$252.00- 18 -248$248.00
36Team #15$64.00 EachTeam #40$63.00 EachTeam #4$62.00 Each
37
38
39TEAM EVENT19th PlaceTEAM EVENT20th PlaceTEAM EVENT20th Place
40Incredi-Bowls2482I GOT ONE2477Ain't Got No Haters2477
41- 19 -244$244.00- 20 -240$238.00- 21 -236$238.00
42Team #22$61.00 EachTeam #19$60.00 EachTeam #45$60.00 Each
43
44
45TEAM EVENT22nd PlaceTEAM EVENT23rd PlaceTEAM EVENT24th Place
46Los Bowlrachos2472Get A X or UR WALKING!!2470Oldies but Goodies2468
47- 22 -232$232.00- 23 -228$228.00- 24 -224$224.00
48Team #24$58.00 EachTeam #32$57.00 EachTeam #26$56.00 Each
49
50
51TEAM EVENT25th PlaceTEAM EVENT26th PlaceTEAM EVENT27th Place
52Mad Monster Party2457FTP - Balls DEEPER!!2445GUARDIANS OF THE ALLEY!2438
53- 25 -220$220.00- 26 -216$216.00- 27 -212$212.00
54Team #28$55.00 EachTeam #25$54.00 EachTeam #8$53.00 Each
55
56
57TEAM EVENT28th PlaceTEAM EVENT29th PlaceTEAM EVENT30th Place
58Balls of Glory2433Better With BEER!!2424Team 032422
59- 28 -208$208.00- 29 -204$204.00- 30 -200$200.00
60Team #34$52.00 EachTeam #11$51.00 EachTeam #3$50.00 Each
61
62
63TEAM EVENT31st PlaceTEAM EVENT32nd PlaceTEAM EVENT32nd Place
64BAZINGA!2405NO MAS PALITOS2402Yo-Yo & The GUYS2402
65- 31 -196$196.00- 32 -192$190.00- 33 -188$190.00
66Team #12$49.00 EachTeam #29$47.50 EachTeam #44$47.50 Each
67
68
Team-Event-Labels
Cell Formulas
RangeFormula
A3A3=IF('VEGAS - Main'!$C$2>=1,"TEAM EVENT","")
A4A4=IF($I3="TEAM EVENT",'Team Event'!$B7,"")
C3C3=IF('VEGAS - Main'!$C$2>=1,$S1," ")
C4C4=IF($A3="TEAM EVENT",'Team Event'!$C7,"")
E3E3=IF('VEGAS - Main'!$C$2>=2,"TEAM EVENT","")
E4E4=IF($I3="TEAM EVENT",'Team Event'!$B8,"")
G3G3=IF('VEGAS - Main'!$C$2>=2,$S2," ")
G4G4=IF($E3="TEAM EVENT",'Team Event'!$C8,"")
I3I3=IF('VEGAS - Main'!$C$2>=3,"TEAM EVENT","")
I4I4=IF($I3="TEAM EVENT",'Team Event'!$B9,"")
K3K3=IF('VEGAS - Main'!$C$2>=3,$S3," ")
K4K4=IF($I3="TEAM EVENT",'Team Event'!$C9,"")
A5A5=IF('VEGAS - Main'!$C$2>=1,$T1," ")
B5B5='Team Event'!K7
C5C5=IF('VEGAS - Main'!$C$2>=1,'Team Event'!$F7," ")
A6A6=IF($A3="TEAM EVENT","Team #","")
B6B6=IF($I3="TEAM EVENT",'Team Event'!$A7,"")
C6C6=IF('VEGAS - Main'!$C$2>=1,$C5/4," ")
E5E5=IF('VEGAS - Main'!$C$2>=2,$T2," ")
F5F5='Team Event'!$K8
G5G5=IF('VEGAS - Main'!$C$2>=2,'Team Event'!$F8," ")
E6E6=IF($E3="TEAM EVENT","Team #","")
F6F6=IF($I3="TEAM EVENT",'Team Event'!$A8,"")
G6G6=IF('VEGAS - Main'!$C$2>=2,$G5/4," ")
I5I5=IF('VEGAS - Main'!$C$2>=3,$T3," ")
J5J5='Team Event'!$K9
K5K5=IF('VEGAS - Main'!$C$2>=3,'Team Event'!$F9," ")
I6I6=IF($I3="TEAM EVENT","Team #","")
J6J6=IF($I3="TEAM EVENT",'Team Event'!$A9,"")
K6K6=IF('VEGAS - Main'!$C$2>=3,$K5/4," ")
A9A9=IF('VEGAS - Main'!$C$2>=4,"TEAM EVENT","")
A10A10=IF(A9="TEAM EVENT",'Team Event'!B10,"")
C9C9=IF('VEGAS - Main'!$C$2>=4,$S4," ")
C10C10=IF(A9="TEAM EVENT",'Team Event'!C10,"")
E9E9=IF('VEGAS - Main'!$C$2>=5,"TEAM EVENT","")
E10E10=IF(E9="TEAM EVENT",'Team Event'!B11,"")
G9G9=IF('VEGAS - Main'!$C$2>=5,$S5," ")
G10G10=IF(E9="TEAM EVENT",'Team Event'!C11,"")
I9I9=IF('VEGAS - Main'!$C$2>=6,"TEAM EVENT","")
I10I10=IF(I9="TEAM EVENT",'Team Event'!B12,"")
K9K9=IF('VEGAS - Main'!$C$2>=6,$S6," ")
K10K10=IF(I9="TEAM EVENT",'Team Event'!C12,"")
A11A11=IF('VEGAS - Main'!$C$2>=4,$T4," ")
B11B11='Team Event'!$K10
C11C11=IF('VEGAS - Main'!$C$2>=4,'Team Event'!$F10," ")
A12,I66,E66,A66,I60,E60,A60,I54,E54,A54,I48,E48,A48,I42,E42,A42,I36,E36,A36,I30,E30,A30,I24,E24,A24,I18,E18,A18,I12,E12A12=IF(A9="TEAM EVENT","Team #","")
B12B12=IF(A9="TEAM EVENT",'Team Event'!A10,"")
C12C12=IF('VEGAS - Main'!$C$2>=4,C11/4," ")
E11E11=IF('VEGAS - Main'!$C$2>=5,$T5," ")
F11F11='Team Event'!$K11
G11G11=IF('VEGAS - Main'!$C$2>=5,'Team Event'!$F11," ")
F12F12=IF(E9="TEAM EVENT",'Team Event'!A11,"")
G12G12=IF('VEGAS - Main'!$C$2>=5,G11/4," ")
I11I11=IF('VEGAS - Main'!$C$2>=6,$T6," ")
J11J11='Team Event'!$K12
K11K11=IF('VEGAS - Main'!$C$2>=6,'Team Event'!$F12," ")
J12J12=IF(I9="TEAM EVENT",'Team Event'!A12,"")
K12K12=IF('VEGAS - Main'!$C$2>=6,K11/4," ")
A15A15=IF('VEGAS - Main'!$C$2>=7,"TEAM EVENT","")
A16A16=IF(A15="TEAM EVENT",'Team Event'!B13,"")
C15C15=IF('VEGAS - Main'!$C$2>=7,$S7,"")
C16C16=IF(A15="TEAM EVENT",'Team Event'!C13,"")
E15E15=IF('VEGAS - Main'!$C$2>=8,"TEAM EVENT","")
E16E16=IF(E15="TEAM EVENT",'Team Event'!B14,"")
G15G15=IF('VEGAS - Main'!$C$2>=8,$S8,"")
G16G16=IF(E15="TEAM EVENT",'Team Event'!C14,"")
I15I15=IF('VEGAS - Main'!$C$2>=9,"TEAM EVENT","")
I16I16=IF(I15="TEAM EVENT",'Team Event'!B15,"")
K15K15=IF('VEGAS - Main'!$C$2>=9,$S9,"")
K16K16=IF(I15="TEAM EVENT",'Team Event'!C15,"")
A17A17=IF('VEGAS - Main'!$C$2>=7,$T7," ")
B17B17='Team Event'!$K13
C17C17=IF(A15="TEAM EVENT",'Team Event'!$F13," ")
B18B18=IF(A15="TEAM EVENT",'Team Event'!A13,"")
C18C18=IF('VEGAS - Main'!$C$2>=7,C17/4," ")
E17E17=IF('VEGAS - Main'!$C$2>=8,$T8," ")
F17F17='Team Event'!$K14
G17G17=IF(E15="TEAM EVENT",'Team Event'!$F14," ")
F18F18=IF(E15="TEAM EVENT",'Team Event'!A14,"")
G18G18=IF('VEGAS - Main'!$C$2>=8,G17/4," ")
I17I17=IF('VEGAS - Main'!$C$2>=9,$T9," ")
J17J17='Team Event'!$K15
K17K17=IF(I15="TEAM EVENT",'Team Event'!$F15," ")
J18J18=IF(I15="TEAM EVENT",'Team Event'!A15,"")
K18K18=IF('VEGAS - Main'!$C$2>=9,K17/4," ")
A21A21=IF('VEGAS - Main'!$C$2>=10,"TEAM EVENT","")
A22A22=IF(A21="TEAM EVENT",'Team Event'!B16,"")
C21C21=IF('VEGAS - Main'!$C$2>=10,$S10,"")
C22C22=IF(A21="TEAM EVENT",'Team Event'!C16,"")
E21E21=IF('VEGAS - Main'!$C$2>=11,"TEAM EVENT","")
E22E22=IF(E21="TEAM EVENT",'Team Event'!B17,"")
G21G21=IF('VEGAS - Main'!$C$2>=11,$S11,"")
G22G22=IF(E21="TEAM EVENT",'Team Event'!C17,"")
I21I21=IF('VEGAS - Main'!$C$2>=12,"TEAM EVENT","")
I22I22=IF(I21="TEAM EVENT",'Team Event'!B18,"")
K21K21=IF('VEGAS - Main'!$C$2>=12,$S12,"")
K22K22=IF(I21="TEAM EVENT",'Team Event'!C18,"")
A23A23=IF('VEGAS - Main'!$C$2>=10,$T10," ")
B23B23='Team Event'!$K16
C23C23=IF(A21="TEAM EVENT",'Team Event'!$F16," ")
B24B24=IF(A21="TEAM EVENT",'Team Event'!A16,"")
C24C24=IF('VEGAS - Main'!$C$2>=10,C23/4," ")
E23E23=IF('VEGAS - Main'!$C$2>=11,$T11," ")
F23F23='Team Event'!$K17
G23G23=IF(E21="TEAM EVENT",'Team Event'!$F17," ")
F24F24=IF(E21="TEAM EVENT",'Team Event'!A17,"")
G24G24=IF('VEGAS - Main'!$C$2>=11,G23/4," ")
I23I23=IF('VEGAS - Main'!$C$2>=12,$T12," ")
J23J23='Team Event'!$K18
K23K23=IF(I21="TEAM EVENT",'Team Event'!$F18," ")
J24J24=IF(I21="TEAM EVENT",'Team Event'!A18,"")
K24K24=IF('VEGAS - Main'!$C$2>=12,K23/4," ")
A27A27=IF('VEGAS - Main'!$C$2>=13,"TEAM EVENT","")
A28A28=IF(A27="TEAM EVENT",'Team Event'!B19,"")
C27C27=IF('VEGAS - Main'!$C$2>=13,$S13,"")
C28C28=IF(A27="TEAM EVENT",'Team Event'!C19,"")
E27E27=IF('VEGAS - Main'!$C$2>=14,"TEAM EVENT","")
E28E28=IF(E27="TEAM EVENT",'Team Event'!B20,"")
G27G27=IF('VEGAS - Main'!$C$2>=14,$S14,"")
G28G28=IF(E27="TEAM EVENT",'Team Event'!C20,"")
I27I27=IF('VEGAS - Main'!$C$2>=15,"TEAM EVENT","")
I28I28=IF(I27="TEAM EVENT",'Team Event'!B21,"")
K27K27=IF('VEGAS - Main'!$C$2>=15,$S15,"")
K28K28=IF(I27="TEAM EVENT",'Team Event'!C21,"")
A29A29=IF('VEGAS - Main'!$C$2>=13,$T13," ")
B29B29='Team Event'!$K19
C29C29=IF(A27="TEAM EVENT",'Team Event'!$F19," ")
B30B30=IF(A27="TEAM EVENT",'Team Event'!A19,"")
C30C30=IF('VEGAS - Main'!$C$2>=13,C29/4," ")
E29E29=IF('VEGAS - Main'!$C$2>=14,$T14," ")
F29F29='Team Event'!$K20
G29G29=IF(E27="TEAM EVENT",'Team Event'!$F20," ")
F30F30=IF(E27="TEAM EVENT",'Team Event'!A20,"")
G30G30=IF('VEGAS - Main'!$C$2>=14,G29/4," ")
I29I29=IF('VEGAS - Main'!$C$2>=15,$T15," ")
J29J29='Team Event'!$K21
K29K29=IF(I27="TEAM EVENT",'Team Event'!$F21," ")
J30J30=IF(I27="TEAM EVENT",'Team Event'!A21,"")
K30K30=IF('VEGAS - Main'!$C$2>=15,K29/4," ")
A33A33=IF('VEGAS - Main'!$C$2>=16,"TEAM EVENT","")
A34A34=IF(A33="TEAM EVENT",'Team Event'!B22,"")
C33C33=IF('VEGAS - Main'!$C$2>=16,$S16,"")
C34C34=IF(A33="TEAM EVENT",'Team Event'!C22,"")
E33E33=IF('VEGAS - Main'!$C$2>=17,"TEAM EVENT","")
E34E34=IF(E33="TEAM EVENT",'Team Event'!B23,"")
G33G33=IF('VEGAS - Main'!$C$2>=17,$S17,"")
G34G34=IF(E33="TEAM EVENT",'Team Event'!C23,"")
I33I33=IF('VEGAS - Main'!$C$2>=18,"TEAM EVENT","")
I34I34=IF(I33="TEAM EVENT",'Team Event'!B24,"")
K33K33=IF('VEGAS - Main'!$C$2>=18,$S18,"")
K34K34=IF(I33="TEAM EVENT",'Team Event'!C24,"")
A35A35=IF('VEGAS - Main'!$C$2>=16,$T16," ")
B35B35='Team Event'!$K22
C35C35=IF(A33="TEAM EVENT",'Team Event'!$F22," ")
B36B36=IF(A33="TEAM EVENT",'Team Event'!A22,"")
C36C36=IF('VEGAS - Main'!$C$2>=16,C35/4," ")
E35E35=IF('VEGAS - Main'!$C$2>=17,$T17," ")
F35F35='Team Event'!$K23
G35G35=IF(E33="TEAM EVENT",'Team Event'!$F23," ")
F36F36=IF(E33="TEAM EVENT",'Team Event'!A23,"")
G36G36=IF('VEGAS - Main'!$C$2>=17,G35/4," ")
I35I35=IF('VEGAS - Main'!$C$2>=18,$T18," ")
J35J35='Team Event'!$K24
K35K35=IF(I33="TEAM EVENT",'Team Event'!$F24," ")
J36J36=IF(I33="TEAM EVENT",'Team Event'!A24,"")
K36K36=IF('VEGAS - Main'!$C$2>=18,K35/4," ")
A39A39=IF('VEGAS - Main'!$C$2>=19,"TEAM EVENT","")
A40A40=IF(A39="TEAM EVENT",'Team Event'!B25,"")
C39C39=IF('VEGAS - Main'!$C$2>=19,$S19,"")
C40C40=IF(A39="TEAM EVENT",'Team Event'!C25,"")
E39E39=IF('VEGAS - Main'!$C$2>=20,"TEAM EVENT","")
E40E40=IF(E39="TEAM EVENT",'Team Event'!B26,"")
G39G39=IF('VEGAS - Main'!$C$2>=20,$S20,"")
G40G40=IF(E39="TEAM EVENT",'Team Event'!C26,"")
I39I39=IF('VEGAS - Main'!$C$2>=21,"TEAM EVENT","")
I40I40=IF(I39="TEAM EVENT",'Team Event'!B27,"")
K39K39=IF('VEGAS - Main'!$C$2>=21,$S21,"")
K40K40=IF(I39="TEAM EVENT",'Team Event'!C27,"")
A41A41=IF('VEGAS - Main'!$C$2>=19,$T19," ")
B41B41='Team Event'!$K25
C41C41=IF(A39="TEAM EVENT",'Team Event'!$F25," ")
B42B42=IF(A39="TEAM EVENT",'Team Event'!A25,"")
C42C42=IF('VEGAS - Main'!$C$2>=19,C41/4," ")
E41E41=IF('VEGAS - Main'!$C$2>=20,$T20," ")
F41F41='Team Event'!$K26
G41G41=IF(E39="TEAM EVENT",'Team Event'!$F26," ")
F42F42=IF(E39="TEAM EVENT",'Team Event'!A26,"")
G42G42=IF(ISERROR(G41/4),"",ROUNDUP(IF('VEGAS - Main'!$C$2>=20,G41/4," "),0))
I41I41=IF('VEGAS - Main'!$C$2>=21,$T21," ")
J41J41='Team Event'!$K27
K41K41=IF(I39="TEAM EVENT",'Team Event'!$F27," ")
J42J42=IF(I39="TEAM EVENT",'Team Event'!A27,"")
K42K42=ROUNDUP(IF('VEGAS - Main'!$C$2>=21,$K41/4," "),0)
A45A45=IF('VEGAS - Main'!$C$2>=22,"TEAM EVENT","")
A46A46=IF(A45="TEAM EVENT",'Team Event'!B28,"")
C45C45=IF('VEGAS - Main'!$C$2>=22,$S22,"")
C46C46=IF(A45="TEAM EVENT",'Team Event'!C28,"")
E45E45=IF('VEGAS - Main'!$C$2>=23,"TEAM EVENT","")
E46E46=IF(E45="TEAM EVENT",'Team Event'!B29,"")
G45G45=IF('VEGAS - Main'!$C$2>=23,$S23,"")
G46G46=IF(E45="TEAM EVENT",'Team Event'!C29,"")
I45I45=IF('VEGAS - Main'!$C$2>=24,"TEAM EVENT","")
I46I46=IF(I45="TEAM EVENT",'Team Event'!B30,"")
K45K45=IF('VEGAS - Main'!$C$2>=24,$S24,"")
K46K46=IF(I45="TEAM EVENT",'Team Event'!C30,"")
A47A47=IF('VEGAS - Main'!$C$2>=22,$T22," ")
B47B47='Team Event'!$K28
C47C47=IF(A45="TEAM EVENT",'Team Event'!$F28," ")
B48B48=IF(A45="TEAM EVENT",'Team Event'!A28,"")
C48C48=IF('VEGAS - Main'!$C$2>=22,C47/4," ")
E47E47=IF('VEGAS - Main'!$C$2>=23,$T23," ")
F47F47='Team Event'!$K29
G47G47=IF(E45="TEAM EVENT",'Team Event'!$F29," ")
F48F48=IF(E45="TEAM EVENT",'Team Event'!A29,"")
G48G48=IF('VEGAS - Main'!$C$2>=23,G47/4," ")
I47I47=IF('VEGAS - Main'!$C$2>=24,$T24," ")
J47J47='Team Event'!$K30
K47K47=IF(I45="TEAM EVENT",'Team Event'!$F30," ")
J48J48=IF(I45="TEAM EVENT",'Team Event'!A30,"")
K48K48=IF('VEGAS - Main'!$C$2>=24,K47/4," ")
A51A51=IF('VEGAS - Main'!$C$2>=25,"TEAM EVENT","")
A52A52=IF(A51="TEAM EVENT",'Team Event'!B31,"")
C51C51=IF('VEGAS - Main'!$C$2>=25,$S25,"")
C52C52=IF(A51="TEAM EVENT",'Team Event'!C31,"")
E51E51=IF('VEGAS - Main'!$C$2>=26,"TEAM EVENT","")
E52E52=IF(E51="TEAM EVENT",'Team Event'!B32,"")
G51G51=IF('VEGAS - Main'!$C$2>=26,$S26,"")
G52G52=IF(E51="TEAM EVENT",'Team Event'!C32,"")
I51I51=IF('VEGAS - Main'!$C$2>=27,"TEAM EVENT","")
I52I52=IF(I51="TEAM EVENT",'Team Event'!B33,"")
K51K51=IF('VEGAS - Main'!$C$2>=27,$S27,"")
K52K52=IF(I51="TEAM EVENT",'Team Event'!C33,"")
A53A53=IF('VEGAS - Main'!$C$2>=25,$T25," ")
B53B53='Team Event'!$K31
C53C53=IF(A51="TEAM EVENT",'Team Event'!$F31," ")
B54B54=IF(A51="TEAM EVENT",'Team Event'!A31,"")
C54C54=IF('VEGAS - Main'!$C$2>=25,C53/4," ")
E53E53=IF('VEGAS - Main'!$C$2>=26,$T26," ")
F53F53=IF('VEGAS - Main'!$C$2>=26,'Team Event'!$K32,"")
G53G53=IF(E51="TEAM EVENT",'Team Event'!$F32," ")
F54F54=IF(E51="TEAM EVENT",'Team Event'!A32,"")
G54G54=IF('VEGAS - Main'!$C$2>=26,G53/4," ")
I53I53=IF('VEGAS - Main'!$C$2>=27,$T27," ")
J53J53=IF('VEGAS - Main'!$C$2>=27,'Team Event'!$K33,"")
K53K53=IF(I51="TEAM EVENT",'Team Event'!$F33," ")
J54J54=IF(I51="TEAM EVENT",'Team Event'!A33,"")
K54K54=IF('VEGAS - Main'!$C$2>=27,K53/4," ")
A57A57=IF('VEGAS - Main'!$C$2>=28,"TEAM EVENT","")
A58A58=IF(A57="TEAM EVENT",'Team Event'!B34,"")
C57C57=IF('VEGAS - Main'!$C$2>=28,$S28,"")
C58C58=IF(A57="TEAM EVENT",'Team Event'!C34,"")
E57E57=IF('VEGAS - Main'!$C$2>=29,"TEAM EVENT","")
E58E58=IF(E57="TEAM EVENT",'Team Event'!B35,"")
G57G57=IF('VEGAS - Main'!$C$2>=29,$S29,"")
G58G58=IF(E57="TEAM EVENT",'Team Event'!C35,"")
I57I57=IF('VEGAS - Main'!$C$2>=30,"TEAM EVENT","")
I58I58=IF(I57="TEAM EVENT",'Team Event'!B36,"")
K57K57=IF('VEGAS - Main'!$C$2>=30,$S30,"")
K58K58=IF(I57="TEAM EVENT",'Team Event'!C36,"")
A59A59=IF('VEGAS - Main'!$C$2>=28,$T28," ")
B59B59=IF('VEGAS - Main'!$C$2>=28,'Team Event'!$K34,"")
C59C59=IF(A57="TEAM EVENT",'Team Event'!$F34," ")
B60B60=IF(A57="TEAM EVENT",'Team Event'!A34,"")
C60C60=IF('VEGAS - Main'!$C$2>=28,C59/4," ")
E59E59=IF('VEGAS - Main'!$C$2>=29,$T29," ")
F59F59=IF('VEGAS - Main'!$C$2>=29,'Team Event'!$K35,"")
G59G59=IF(E57="TEAM EVENT",'Team Event'!$F35," ")
F60F60=IF(E57="TEAM EVENT",'Team Event'!A35,"")
G60G60=IF('VEGAS - Main'!$C$2>=29,G59/4," ")
I59I59=IF('VEGAS - Main'!$C$2>=30,$T30," ")
J59J59=IF('VEGAS - Main'!$C$2>=30,'Team Event'!$K36,"")
K59K59=IF(I57="TEAM EVENT",'Team Event'!$F36," ")
J60J60=IF(I57="TEAM EVENT",'Team Event'!A36,"")
K60K60=IF('VEGAS - Main'!$C$2>=30,K59/4," ")
A63A63=IF('VEGAS - Main'!$C$2>=31,"TEAM EVENT","")
A64A64=IF(A63="TEAM EVENT",'Team Event'!B37,"")
C63C63=IF('VEGAS - Main'!$C$2>=31,$S31,"")
C64C64=IF(A63="TEAM EVENT",'Team Event'!C37,"")
E63E63=IF('VEGAS - Main'!$C$2>=32,"TEAM EVENT","")
E64E64=IF(E63="TEAM EVENT",'Team Event'!B38,"")
G63G63=IF('VEGAS - Main'!$C$2>=32,$S32,"")
G64G64=IF(E63="TEAM EVENT",'Team Event'!C38,"")
I63I63=IF('VEGAS - Main'!$C$2>=33,"TEAM EVENT","")
I64I64=IF(I63="TEAM EVENT",'Team Event'!B39,"")
K63K63=IF('VEGAS - Main'!$C$2>=33,$S33,"")
K64K64=IF(I63="TEAM EVENT",'Team Event'!C39,"")
A65A65=IF('VEGAS - Main'!$C$2>=31,$T31," ")
B65B65=IF('VEGAS - Main'!$C$2>=31,'Team Event'!$K37,"")
C65C65=IF(A63="TEAM EVENT",'Team Event'!$F37," ")
B66B66=IF(A63="TEAM EVENT",'Team Event'!A37,"")
C66C66=IF('VEGAS - Main'!$C$2>=31,C65/4," ")
E65E65=IF('VEGAS - Main'!$C$2>=32,$T32," ")
F65F65=IF('VEGAS - Main'!$C$2>=32,'Team Event'!$K38,"")
G65G65=IF(E63="TEAM EVENT",'Team Event'!$F38," ")
F66F66=IF(E63="TEAM EVENT",'Team Event'!A38,"")
G66G66=IF('VEGAS - Main'!$C$2>=32,G65/4," ")
I65I65=IF('VEGAS - Main'!$C$2>=33,$T33," ")
J65J65=IF('VEGAS - Main'!$C$2>=33,'Team Event'!$K39,"")
K65K65=IF(I63="TEAM EVENT",'Team Event'!$F39," ")
J66J66=IF(I63="TEAM EVENT",'Team Event'!A39,"")
K66K66=IF('VEGAS - Main'!$C$2>=33,K65/4," ")
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A1:K121Expression=COUNTIF($C$4:$K$120, C4)>1textYES
C4Expression=COUNTIF($A$1:$K$8, A2)>1textYES
C6Expression=ISNUMBER(C6)textYES
G6,K6,C12,G12,K12,K18,G18,C18,C24,G24,K24,K30,G30,C30,C36,G36,K36,K42,G42,C42,C48,G48,K48,C54,G54,K54,K60,G60,C60,C66,G66,K66,C72,G72,K72,C78,G78,K78,K84,G84,C84Expression=ISNUMBER(C6)textYES
K5,K11,K17,K23,K29,K35,K41,K47,K53,K59,K65,K71Expression=ISNUMBER(K5)textYES
C5,C11,C17,C23,C29,C35,C41,C47,C53,C59,C65,C71,G5,G11,G17,G23,G29,G35,G41,G47,G53,G59,G65,G71,C77,G77,C83,G83,C89,C95,G95,C101,G101,C107,G107,C113,G113,C119,G119Expression=ISNUMBER(C5)textYES
C5Expression=ISNUMBER(C5)textYES
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,731
Office Version
  1. 365
  2. 2010
I'm sorry, but you have me at a complete loss and total confusion.
 

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
364
I'm sorry, but you have me at a complete loss and total confusion.
Sorry about that - I was trying to use the xl2bb software to upload my Excel - It seems to not have come out very well I guess :(

Ok let me start over - I run a Bowling League - At times we have Team that shoot the exact same Score for Total Pins.
When this happens we have a Tie. Sometimes we have more then one team shoot the same score - It could be 3 teams 4 teams etc. Once I have a Tie Score I wanted that Score to Display in RED. My Code has 120 Lines & 60 Teams Max. My Totals are in Columns C, G & K with spaces and other values between the lines. So that was what I was trying to accomplish in a nut shell. I tried doing the Conditional Formatting but I messed it up as you see above allot more then the ties highlighted in Red :( Helpppppppppppppppppppppppp Thanks for your Help - Stay Safe
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,731
Office Version
  1. 365
  2. 2010
Will try again. Now, is it correct that you want the focus on ONLY lines 4, 10, 16, 22, 28, etc. to determine if there's a tie in those respective rows (i.e. a tie in row 4, a tie in row 10, etc.) ?
 

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
364

ADVERTISEMENT

Will try again. Now, is it correct that you want the focus on ONLY lines 4, 10, 16, 22, 28, etc. to determine if there's a tie in those respective rows (i.e. a tie in row 4, a tie in row 10, etc.) ?
Yes Lines 4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64, 70, 76, 82, 88, 94, 100, 106, 112 & 118. Thanks for your help
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,731
Office Version
  1. 365
  2. 2010
(as long as you don't change the structure again...LOL) here's a sample result and a VBA routine to handle it.

1619637022985.png


Code:
Sub highlight()
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
lr = lr - 2
For i = 4 To lr Step 6
  If Cells(i, 3) = Cells(i, 7) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 7) = Cells(i, 11) Then
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  End If
Next i
End Sub
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,731
Office Version
  1. 365
  2. 2010

ADVERTISEMENT

I believe I missed a case. Hold on.

Maybe this:
Code:
Sub highlight()
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
lr = lr - 2
For i = 4 To lr Step 6
  If Cells(i, 3) = Cells(i, 7) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  If Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  End If
  ElseIf Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 7) = Cells(i, 11) Then
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  End If
Next i
End Sub
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,731
Office Version
  1. 365
  2. 2010
I think it can be shortened to this:
Code:
Sub highlight()
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
lr = lr - 2
For i = 4 To lr Step 6
  If Cells(i, 3) = Cells(i, 7) And Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 7) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 7) = Cells(i, 11) Then
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  End If
Next i
End Sub
 
Solution

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
364
I think it can be shortened to this:
Code:
Sub highlight()
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
lr = lr - 2
For i = 4 To lr Step 6
  If Cells(i, 3) = Cells(i, 7) And Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 7) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 7) = Cells(i, 11) Then
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  End If
Next i
End Sub
That Worked Thanks :) Stay Safe
 

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
364
I think it can be shortened to this:
Code:
Sub highlight()
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
lr = lr - 2
For i = 4 To lr Step 6
  If Cells(i, 3) = Cells(i, 7) And Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 7) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 7).Interior.ColorIndex = 3
  ElseIf Cells(i, 3) = Cells(i, 11) Then
  Cells(i, 3).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  ElseIf Cells(i, 7) = Cells(i, 11) Then
  Cells(i, 7).Interior.ColorIndex = 3
  Cells(i, 11).Interior.ColorIndex = 3
  End If
Next i
End Sub
Question, is there a way to have this code run every time I enter that work-sheet?
Let me know thanks - Stay Safe
 

Watch MrExcel Video

Forum statistics

Threads
1,129,471
Messages
5,636,501
Members
416,919
Latest member
twc2c

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top