Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,168
- Office Version
- 365
- 2019
- Platform
- Windows
I want to thank everyone for all the help in the past. I am trying to get this to work but am having a problem this is the problem area If cells(i,2)*cells(i,9). Could someone please straighten me out.
Thanks in advance Stephen.
Sub doesitequal()
Dim i as Long
For i = 1 to 100
If cells(i,2)*cells(i,9)<>cells(i,10) then cells(i,13).interior.colorindex = 3
Next i
End Sub
Thanks in advance Stephen.
Sub doesitequal()
Dim i as Long
For i = 1 to 100
If cells(i,2)*cells(i,9)<>cells(i,10) then cells(i,13).interior.colorindex = 3
Next i
End Sub