Hello, I'm working on a macro to change the color of the row between column W to AN if in column K the value is "FCA" (without quotes).
So far I have this, but it doesn't work:
Sub Test() For Each cell In Range("K1", Cells(Rows.Count, "K").End(xlUp)) If InStr(1, cell, "FCA") Then Range("W" & cell.Row & ":AN" & cell.Row).Interior.ColorIndex = 3 End If Next cell End Sub
Bookmarks