Thanks for that, relised is was me being an idiot. Every time I was using the conditional format tool in excel, it was automatically putting a $ in front of the cell in question so I couldn't format it to others. All sorted now, thanks again.