Hi Weety
We would need to see a copy of your spreadsheet (or a sample extract) for us to see what is happening. We may then be able to advise you.
Have you checked to see if ANY conditional formatting has been applied to the template you are using?
Tony(OTPM)