# Winning Score Bold?

##### Active Member
Hi All,

Looking for a better way to distinguish a Winning goal, possibly to display in Bold. In addition, a better way to display Away or Home Win, Loss, or Tie in cells K5 & T5 .
As in this example, Oakland @ New England. England Win 30, Oakland Loss 20.

Paul
NFL Probability.xls
ABCDEFGHIJKLMNOPQRSTU
4NoWkNoDateAwayA1A2A3A4AOTAway ScoreAway W/LMax Away PointsHomeH1H2H3H4HOTHome ScoreHome W/LMax Home Points
511Thu Sep 08, 05OAK770620LossDALNE1076730WinNYG
NFL_0506 DataBase

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Not sure about bold, but conditional formatting would work. You could highlight the background of the winning cell.

Colin.

Worked great, another question

rs2k

Yes, that worked fine. Now this has me thinking, looking at cells L5 & U5 the formula displays the highest goal between teams. How could I place a conditional format in cell D16 where Dal is displayed and cell M17 where NYG is displayed.

Here's the sample data:

Thanks
Paul

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=22><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - NFL Probability.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows Windows 2000 </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=22><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=22><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value==SUM(E5:I5) selected>J5<OPTION value='=IF(S5<J5,"Win","Loss")'>K5<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L5<OPTION value==SUM(N5:R5)>S5<OPTION value='=IF(S5>J5,"Win","Loss")'>T5<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U5<OPTION value==SUM(E6:I6)>J6<OPTION value='=IF(S6<J6,"Win","Loss")'>K6<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L6<OPTION value==SUM(N6:R6)>S6<OPTION value='=IF(S6>J6,"Win","Loss")'>T6<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U6<OPTION value==SUM(E7:I7)>J7<OPTION value='=IF(S7<J7,"Win","Loss")'>K7<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L7<OPTION value==SUM(N7:R7)>S7<OPTION value='=IF(S7>J7,"Win","Loss")'>T7<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U7<OPTION value==SUM(E8:I8)>J8<OPTION value='=IF(S8<J8,"Win","Loss")'>K8<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L8<OPTION value==SUM(N8:R8)>S8<OPTION value='=IF(S8>J8,"Win","Loss")'>T8<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U8<OPTION value==SUM(E9:I9)>J9<OPTION value='=IF(S9<J9,"Win","Loss")'>K9<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L9<OPTION value==SUM(N9:R9)>S9<OPTION value='=IF(S9>J9,"Win","Loss")'>T9<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U9<OPTION value==SUM(E10:I10)>J10<OPTION value='=IF(S10<J10,"Win","Loss")'>K10<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L10<OPTION value==SUM(N10:R10)>S10<OPTION value='=IF(S10>J10,"Win","Loss")'>T10<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U10<OPTION value==SUM(E11:I11)>J11<OPTION value='=IF(S11<J11,"Win","Loss")'>K11<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L11<OPTION value==SUM(N11:R11)>S11<OPTION value='=IF(S11>J11,"Win","Loss")'>T11<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U11<OPTION value==SUM(E12:I12)>J12<OPTION value='=IF(S12<J12,"Win","Loss")'>K12<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L12<OPTION value==SUM(N12:R12)>S12<OPTION value='=IF(S12>J12,"Win","Loss")'>T12<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U12<OPTION value==SUM(E13:I13)>J13<OPTION value='=IF(S13<J13,"Win","Loss")'>K13<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L13<OPTION value==SUM(N13:R13)>S13<OPTION value='=IF(S13>J13,"Win","Loss")'>T13<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U13<OPTION value==SUM(E14:I14)>J14<OPTION value='=IF(S14<J14,"Win","Loss")'>K14<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L14<OPTION value==SUM(N14:R14)>S14<OPTION value='=IF(S14>J14,"Win","Loss")'>T14<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U14<OPTION value==SUM(E15:I15)>J15<OPTION value='=IF(S15<J15,"Win","Loss")'>K15<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L15<OPTION value==SUM(N15:R15)>S15<OPTION value='=IF(S15>J15,"Win","Loss")'>T15<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U15<OPTION value==SUM(E16:I16)>J16<OPTION value='=IF(S16<J16,"Win","Loss")'>K16<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L16<OPTION value==SUM(N16:R16)>S16<OPTION value='=IF(S16>J16,"Win","Loss")'>T16<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U16<OPTION value==SUM(E17:I17)>J17<OPTION value='=IF(S17<J17,"Win","Loss")'>K17<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L17<OPTION value==SUM(N17:R17)>S17<OPTION value='=IF(S17>J17,"Win","Loss")'>T17<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U17<OPTION value==SUM(E18:I18)>J18<OPTION value='=IF(S18<J18,"Win","Loss")'>K18<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L18<OPTION value==SUM(N18:R18)>S18<OPTION value='=IF(S18>J18,"Win","Loss")'>T18<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U18<OPTION value==SUM(E19:I19)>J19<OPTION value='=IF(S19<J19,"Win","Loss")'>K19<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L19<OPTION value==SUM(N19:R19)>S19<OPTION value='=IF(S19>J19,"Win","Loss")'>T19<OPTION value==INDEX(\$M\$5:\$M\$20,MATCH(MAX(\$S\$5:\$S\$20),\$S\$5:\$S\$20,0))>U19<OPTION value==SUM(E20:I20)>J20<OPTION value='=IF(S20<J20,"Win","Loss")'>K20<OPTION value==INDEX(\$D\$5:\$D\$20,MATCH(MAX(\$J\$5:\$J\$20),\$J\$5:\$J\$20,0))>L20<OPTION value==SUM(N20:R20)>S20<OPTION value='=IF(S20>J20,"Win","Loss")'>T20<OPTION value==INDEX(\$M\$21:\$M\$36,MATCH(MAX(\$S\$21:\$S\$36),\$S\$21:\$S\$36,0))>U20</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==SUM(E5:I5) name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">

Paul,
Excuse my ignorance, I don't follow sport in the UK and have no idea what your table is about.

'How could I place a conditional format in cell D16 where Dal is displayed and cell M17 where NYG is displayed.'

What result are you expecting? is it to highlight (Conditional formatting) one of the said cells?, if so which one and how do you reach that decision, is it on a win/Lose basis?

Can you explain a bit more, to a non-sport enthusiast.

Colin.

Replies
2
Views
202
Replies
0
Views
282
Replies
1
Views
123
Replies
0
Views
1K
Replies
2
Views
338

1,203,061
Messages
6,053,308
Members
444,651
Latest member
markkuznetsov1

### 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.

### Which adblocker are you using?

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

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