Create additional action in excel vbo
code:
For Each row As DataRow In rowscoll.Rows
GetWorkbook(handle,Nothing).ActiveSheet.Cells(row.Item("Value"),colref).Interior.Color = RGB(Red_Value, Green_Value, Blue_Value)
next row
Inputs to the action:

Action:

ColRef is number of the column
rowscol is collection of row numbers to color
------------------------------
Karol Pietrzyk
------------------------------