Stop cell reference changing when insert column

Brilliant! This is exactly what I was looking for. My formula is about 12 feet long now, but it does exactly what i want! No if I can only get the conditional formatting to not move into the newly inserted column.