[RESOLVED] color change the entire rows

[kamakshi]

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.

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

[si_the_geek]

You can't just place a String value (.Text) in an If statement without any conditions - you need to put something for it to check.

You could make sure that it doesn't equal an empty string:

If ActiveSheet.Cells(i, 1).Text <> "" And ...

...or that it is Not equal to an empty string:

If Not(ActiveSheet.Cells(i, 1).Text = "") And ...