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
History:
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
History: