Jonnie,
use CustomFunction manipulate tab
In example below I display remaining days before opportunity closing date.
I dragged field closed_date twice. The second time I apply a custom SQL calculating the number of days remaining.
For color please check thread Can we set color in field on the KReport?
Val