Sorry to be a pain,
I am using conditional formatting to set the colour of a cell. I now want to change the colour of the adjoing cell to the same as the conditional format cell. CF doesn't have this as an option, any help on alternatives would be gratefully received.