On Sun, 24 May 2009 10:35:00 -0700, Tom wrote:

Conditional formatting wont work (i think). As the formatting depends on two
values (one constant = DayAverage and one variable = Difference in days).
Each day a record would be added.

Sure it will work. You just need to use the correct formulas.

For example, for RED:

=AND((CurrentDate-StartDate)30,CurrentValue<DayAverage)

and for YELLOW:

=AND((CurrentDate-StartDate)<30,CurrentValue<DayAverage)

In Excel 2003, you can have up to 3 conditional formats
--ron