Ok so this is my code so far, i've tested it to change just one cell but want to apply the rule to the whole row, well actually it would be better to apply to the row upto column CA, but when i use the entirerow it doesnt know what row im talking about. how do i say the row your looking at??
![]()
For Each Cell In Range("B2:B" & LastRow) If Cell.Value = "" And Cell.Offset(0, 1).Value = "" Then EntireRow.Interior.Color = vbYellow End If Next Cell
Bookmarks