>>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
Not to sound like a total idiot but where would I put that? Is this a VBA script? or in a cell?
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams