Excel 2007 : Change color of cell on click

I am attempting to program an excell sheet so that some of the rows change one set of colors when selected while the rest of the rows will change a different set of colors.

Example:

Rows 1,3,5,9 will change red, then, bule, then green

Rows 2,4,6,8 will change Purple, then yellow when clicked.

This is what I have done so far:

Please Login or Register  to view this content.