Hi there,

I've been looking for the relevant code but can't find it online. All I want to do is:

Let's say I've two columns E and F. F column automatically loads the correct background cell colour so that's sorted however I want E column to have the same coloured cells as F column (like a mirror image of F column). I don't want to know all the colour numbers, conditional formatting options etc all I want is simple code to copy the background cell colour from F column to E column.

I'm using MS Office 2007 btw.

Many thanks