hi!
i am trying to do if the column 3 is blank and other coloumns 1 , 2 have values the entire row will be yellow color
column 1 is text and column 2 will be variant and column 3 also vairant
but the below will get error type mismatch.

Code:
If ActiveSheet.Cells(i, 1).Text And ActiveSheet.Cells(i, 2).Text And ActiveSheet.Cells(i, 3).Text = "" Then   ''color because was late
                        Range(Cells(i, 1), Cells(i, 3)).Interior.ColorIndex = 36   '
                 End If