Compare two cells with conditional values and bold cell with greater than numerical value.

Preacherman771

New Member
Joined
Jun 15, 2021
Messages
46
Office Version
  1. 365
Platform
  1. Windows
I have a worksheet comprised of various cells with conditional formulas. What I would like to do is compare two of the cells, they have numerical values, and bold the one which is greater than the other one. On the attached
xl2bb copy, compare I8 & I9 and since in this moment, I9 is greater than, have the result of 31 Bolded. In the other, I16 & I17, bold I16.

NFL 2021 Standing.xlsx
ABCDEFGHIJK
1
2
3Games - Week1
4
5
6Thursday, 09/098:20pmNBCRaymond James Stadium
7
8Cowboys0-1-029
9Buccaneers1-0-031
10
11
12
13
14Sunday, 09/121:00pmCBSFedEx Field
15
16Chargers1-0-020
17Commanders0-1-016
18
19
Week 1
Cell Formulas
RangeFormula
G6,G14G6=INDEX(TeamData[Stadium],MATCH(C9,TeamData[Team],0))
H8:H9,H16:H17H8=IF(C8<>"",INDEX(WeekData[Rec],MATCH(1,($E$3=WeekData[Wk'#])*(C8=WeekData[Team]),0)),"")
I8,I16I8=IF(C8<>"",INDEX(SchedData[ScoreA],MATCH(1,($E$3=SchedData[Wk'#])*(C8=SchedData[TeamA]),0)),"")
I9,I17I9=IF(C9<>"",INDEX(SchedData[ScoreH],MATCH(1,($E$3=SchedData[Wk'#])*(C9=SchedData[TeamH]),0)),"")
C8C8=INDEX(SchedData[TeamA],SMALL(IF(SchedData[Wk'#]=$E$3,IF(SchedData[Date]=C6,ROW(SchedData[Wk'#])-ROW(INDEX(SchedData[Wk'#],1,1))+1)),1))
C9C9=INDEX(SchedData[TeamH],SMALL(IF(SchedData[Wk'#]=$E$3,IF(SchedData[Date]=C6,ROW(SchedData[Wk'#])-ROW(INDEX(SchedData[Wk'#],1,1))+1)),1))
C16C16=INDEX(SchedData[TeamA],SMALL(IF(SchedData[Wk'#]=$E$3,IF(SchedData[Date]=C14,ROW(SchedData[Wk'#])-ROW(INDEX(SchedData[Wk'#],1,1))+1)),2))
C17C17=INDEX(SchedData[TeamH],SMALL(IF(SchedData[Wk'#]=$E$3,IF(SchedData[Date]=C14,ROW(SchedData[Wk'#])-ROW(INDEX(SchedData[Wk'#],1,1))+1)),2))
Press CTRL+SHIFT+ENTER to enter array formulas.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Select I8 & I9 then in conditional formatting select new rule, use a formula & use
Excel Formula:
=I8=MAX(I$8:I$9)
 
Upvote 0
Solution
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,224,817
Messages
6,181,149
Members
453,021
Latest member
Justyna P

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
Back
Top