Sounds like you are doing everything right.
Do you have a sample workbook you can attach. will be easier for someone to spot what may be stopping the colours displaying
I believe it's now attached
(sorry, I had some difficulty as my site is displayed in Chinese and I can't seem to change it back)