In my worksheet I have a Drop down box in D23 with 3 options say 1,2 & 4 plus blanck
what I am seeking to do is that when I select either 1, 2 3 or blank that d10 changes colour - say green for 1 - blue for 2 and yellow for 3 with white for Blank

I have the code to make this happen as indicated above - but I want to extend this for rows - D23 to d28 for the Drop downs and rows d10 to d15 for the colours

I just cannot seem to be able to add to the esisting code to make this happen

Help appreciated