The reference to the style sheet needs to be added to the page where you have the cms code. If you want to see the styles to in the cms admin pages, then you will need to add the reference to those pages as well.
Once you add the reference to the style sheet to the page, and if you are still having an issue, please post with a link to the page or attache the page as an attachment.