Conditional Formating Excel Table

[flipland]

Hi. I would like to have conditional formatting done on an Excel Table based on the MIN and MAX values of every row in the table. Cells of the MIN values are to be highligted in RED with WHITE font. Celss of the MAX values are to be highlighted in GREEN with WHITE font.

I was able to find VBA code to conditionally format by row, but am stuck as to how to make it loop down to the next row. The code is copy-pasted below, as well as a snippet of the table. Would appreciate any help on this. Thanks!

CODE:
Public Sub MIN_MAX_Format()

ActiveSheet.Range("A1").Select
ActiveCell.Offset(1, 1).Select
Range("b2:r2").Select


Dim rg As Range
Dim cond1 As FormatCondition, cond2 As FormatCondition, cond3 As FormatCondition
Set rg = ActiveSheet.Range("B2:R2")

'clear any existing conditional formatting
rg.FormatConditions.Delete

'define the rule for each conditional format
Set cond1 = rg.FormatConditions.Add(xlCellValue, xlEqual, "=$U2")
Set cond2 = rg.FormatConditions.Add(xlCellValue, xlEqual, "=$T2")

'define the format applied for each conditional format
With cond1
.Interior.Color = vbGreen
.Font.Color = vbWhite
End With

With cond2
.Interior.Color = vbRed
.Font.Color = vbWhite
End With

ActiveCell.Offset(1, 0).Select


End Sub



The table looks like this:

https://drive.google.com/file/d/1yTWNE9WaHTzBJRUfXZ_VKq5v8ZdJZdFf/view?usp=sharing

Country Name	Bangladesh	Bhutan	China	Hong Kong SAR, China	Indonesia	Japan	Lao PDR	Sri Lanka	Macao SAR, China	Myanmar	Malaysia	Nepal	Philippines	Singapore	Thailand	Vietnam	Korea, Rep.	MIN	MAX
1960	89		90	429		479		143			235	51	254	428	101		158		51	479
1961	97		76	437		564		143			226	52	267	449	107		94		52	564
1962	100		71	488		634		139			230	55	157	472	114		106		55	634

<tbody>
</tbody>

 

[Fluff]

You're welcome & thanks for the feedback