I'll try to describe the settings I use on the camera as best as I could, hope it will help you.
1: set camera into macro mode.
2: turns off the flash, for me flash just bounce off the glass and give glares in the picture.
3: enter "function set" mode and change to manual mode.
4: initially set exposure to 0 (middle), you can change these up or down base on how well lit the object is.
5: set the white balance option to "evaluate white balance", this way you can press the "menu" button and it'll auto adjust the white balancing.
6: "my colors off"
7: for the focus mode leave in "evaluative", you can to switch these around to get the right focusing mode for different pictures.
Also, I find that taking pictures at night under your MH lighting helps a lot, give you clearer pictures. In the day light from windows makes the picture not as vibrant, possibly due to reflection from glass. Sometimes the auto focus feature will focus at different spots around the object you're trying to take a picture of, so you'll have to change the angle, position of the camera so that the auto focus feature focuses on the right object. Sometimes adjusting the "focusing mode" (evaluative, center weighted, etc) will help too. Also, I have my picture size set as "M1" 2272x1704, not sure if this option makes a different in picture clarity. Hope this helps, If something is not clear, ask me.
One more thing, the lens on these camera take good macro pictures when the object is less 6" away from the lens. Anything further away, it's hard to take good pictures.