This macro is supposed to look down column B and see if the value in each cell is greater than the value to the right(in column C). If so, it should color the cell. But it doesn't work!!! Help
![]()
Sub Man_Whydoesntthiswork() Dim count As Integer Dim i As Integer For i = 1 To 100 count = 2 If Cells(count, 2) > Cells(count, 3) Then Cells(count, 2).Interior.Color = 5 End If count = count + 1 Next i End Sub
Bookmarks