How to highlight a row in a listview?

How to find max/min value using VBA for next loop...? and highlight the row with colour?

• i) Write a VBA code to fill in the student numbers in the second column using For-Next loop; at the same time, input the marks for each student using input box and fill them in the third column. (ii) Calculate the average marks of the students using For-Next loop and output it to a cell. (iii) Using For-Next loop, find out the maximum and minimum marks and highlight the rows using red and green colour, respectively. i have done part 1 and part 2.. no sure how to do part 3

• Answer:

  Here is one way: Sub MinMax() Dim LastRow LastRow = Range("C" & Rows.Count).End(xlUp).Row For i = 1 To LastRow If Cells(i, "C").Value = Application.Max(Range("C1:C" & LastRow)) Then Cells(i, "C").Interior.ColorIndex = 3 ElseIf Cells(i, "C").Value = Application.Min(Range("C1:C" & LastRow)) Then Cells(i, "C").Interior.ColorIndex = 4 Else Cells(i, "C").Interior.ColorIndex = xlNone End If Next End Sub