>>>>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 ?

This is still in the design phase so no hard fast rules yet. I want for the actions to take place while the user is modifying the table... er, spreadsheet. So I was looking for a place to incorporate a method... (lostfocus, changed, etc) If I can imbed the code into the spreadsheet so the code would work without user intervention while in Excel it would be best. Otherwise i will have to run a VB app as a maintenence item periodicaly. (Less desirable) :)

My sincere thanks in advance,