>I would like to format an excel row based on the contents of a cell in that row. eg if cells in col 6 = passed I want the row to be green. I have made the cell green but not the row. :( Can excel do that? What would be the best tool for this? A VBA addin or just plain ol Excel?
>
>Thank you all so much,


Try this:

Columns("D:D").Select
With Selection.Interior
.ColorIndex = 4
.Pattern = xlSolid
End With