Change text color of a row if data entered is...
Posted by Steve on January 12, 2001 8:00 AM
I currently have this piece of code which only changes the text color in one cell of a row: (totals is in column T or 20 of the current row)
If (Left(Cells(Row, 2), 2) = "01") And (Cells(Row, 7) <> "") Then
totals = totals + 33
Cells(Row, Col).Font.ColorIndex = 5
I would prefer the whole row to have the text color changed. Any idea how to do this?