change row colors in excel

[blackmagic37]

okay so i have this code

<code>
Dim oexcel As Microsoft.Office.Interop.Excel.Application
Dim obook As Microsoft.Office.Interop.Excel.Workbook
Dim osheet As Microsoft.Office.Interop.Excel.Worksheet


oexcel = New Microsoft.Office.Interop.Excel.Application
obook = oexcel.Workbooks.Open("c:\test\test.xls")
osheet = obook.Worksheets(1)

Dim LastRow As Integer = osheet.UsedRange.Rows.Count
osheet.Range("A" & LastRow.ToString + 1).Value = Date.Now
osheet.Range("B" & LastRow.ToString + 1).Value = TextBox1.Text


obook.Save()
obook.Close()
oexcel.Quit()
oexcel = Nothing
</code>

this code basically writes rows to an excel sheet not overwriting any row but systematically enters new lines every time the button is pressed. each row has a column for type of visit i.e. appointment, new, rush

what i want to do is fill the rows with different colors for example if column "B" on whatever row says appointment i want the whole row to be red. ive never had to program the color of an excel row and could use some help! thanks in advance!!

[JBourgeois]

The best way to learn how to do something when working with Excel is to have Excel record a macro that does the operation.

You can do that by calling Tools...Macro...Record New macro.

You perform the operation, setting the color of a row in your case.

You click the Stop Recording Button in the small toolbar that was created when you started the recording. If the toolbar is not visible, you can stop the recording through Tools...Macro.

You then Switch to the VBA editor with Alt-F11. In the VBAProject window in the upper left, you should find a module that contains the recorded macro. The Object.Method necessary to perform the operations you did while recording will be there in plain sight. You only have to adjust them to the variables you used in your .NET code.