(Note: the page it takes you to, to download is very ad heavy but you don't need to click on anything except the download. You don't even need to sign up.)
A wonderful step-by-step tutorial by Grafpedia for coloring an illustration in Photoshop and getting a fairy tale 'feel' by using the burn tool and dodge tool.
Go from the pencil drawing on the left to the finished on the right.