In the crystal report You can also set the color of database field the dynamically. For that you
have to right click the field and select the format object then go to the font and color tab. Click the formula icon opposite to color and a formula editor opens. Put your formula whatever you want to implement and you set your color based on this formula.