Automatic font color based on its value?

Hi,

I was wondering if it was possible to have values from a CCK field have its value automatically colored based on its max and minimum limits. For example, if it's within the limit, the value would be colored green, over its max it would be red, and under its minimum it would be yellow.

Wondering if you can point me in the right direction. I notice there is an option in Views to rewrite the output, but I'm not sure how to go about doing it. Thanks!