Well you think you know how things go...and then you see something that makes you think again...in particular I didn't realise that you could slip HTML inside calculated columns - how useful is that!
This creates formulas, using some simple html and css inside a calcuated column, completely automatically, its rather lovely.http://www.pathtosharepoint.com/HTMLcc/default.aspx and a little script needs putting in a CEWP the script lives here http://pathtosharepoint.wordpress.com/2008/09/01/using-calculated-columns-to-write-html/
Also if you have MOSS and you want KPI's from your Sharepoint Lists then try this
http://sharepointservices.wordpress.com/2008/09/30/how-to-creating-a-kpi-list-based-on-a-sharepoint-lists/
