Only trouble now is how do I expand the code to say work with the
next cell  as in A8 and A9. I have copied the existing code and
changed the cell ref but now it changes all the columns to the same
colours based on the value of what is in cell A7