Attached you will find a few examples based on the Excel UDF. Enjoy!
Worksheet Change Event
This example handles the Excel Worksheet change event when a cell has been changed and sets the color of the cell to red.
Example Excel Events.zip
Set color of every second row
This example sets the background color for every second row in the used range to yellow.
Example Color Rows.zip