>>>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?
My fault !
I should have pointed out that this code was generated with the Excel macro recorder so yes, it's VBA code.
Now, how to apply this to an Excel object that you are creating in VB ?