I am try copy and row from one sheet to another then trying to change multiple cell color based on cell values. However, Last cell was the only cell that changes the color. I am new to VBA/Macro. Below are the codes. Thank you!
For k = 1 To column_count
If ws1.Cells(i, k).value <> ws2.Cells(j, k).value Or (Not IsEmpty(ws1.Cells(i, k).value) And IsEmpty(ws2.Cells(j, k).value)) Or (IsEmpty(ws1.Cells(i, k).value) And Not IsEmpty(ws2.Cells(j, k).value)) Then
ws1.Rows(i).Copy Destination:=ws3.Rows(lastRow3)
'change the cell color to red
ws3.Rows(lastRow3).Cells(1, k).Interior.color = RGB(255, 0, 0)
End If
Next k