Hello there,
I can figure out why I am getting a Type mismatch error 13 for this code.
![]()
If Range("A" & i).Value <> "" And Range("C" & i).Value = "TCI" And Not (Range("F" & i).Value Like "*Due:*") Then Range("F" & i).Interior.ColorIndex = 4 Range("G" & i).Interior.ColorIndex = 3 Else Range("G" & i).Interior.ColorIndex = 2 End If
Bookmarks