Color cells using VBA for backwards compatibility

Hi,

It has been a decade since I used VBA,

After several days of reading forums, VBA tutorials etc I am running into trouble.

I have a 2 workbooks

"Chassi Selector" is completed using 2007 and works perfectly.

"Chassi VBA Edit" is where I am trying to simulate the other file for backwards compatability.

Cells in 2 colums have a drop list.
When a value is selected it needs to color a range of cells.
If a different value is selected it then needs to clear that color and replace it with the new color to the new range size
The first 5 cells I have managed to get it to look and operate correctly.

Excel 2007 allows conditional formatting to achieve what I wanted (more than 3 conditions)but it needs to be backwards compatable for anyone using a earlier version.

My code will work but it is highly repetitive. I am sure there is a simple way to condense the code to achieve the result.

Additionally,

If any one can also include the functionality that
1.If the cells are colored you cannot select a value in another colored cell.
2. THe colored cells will not allow selection if the colors will overlap.

Bump no response

bump no response