Okay first off with the simple question:

I know there is conditional formatting with excel, but it only lets me to set 3 conditions. Is there anyway to add more?

Mainly something like this
<=1 ------- Red
between 1-4 -----------Orange
between 3-6 ------------Yellow
= 6 -------------YellowGreen
IF(SUM(B1:F1)=36, Green)

Look at the follow question and click the link to a good idea what I want.

Advanced:
I am looking for tips, hints, formulas, comments, suggestions for the following.
http://www.hostima.net/paroxsitic/excel.html
It would be insanely awesome if someone could actually get a start on my ideas and post a link to a working copy, I might even spit out some money for it.

Thanks alot.