Straight table visual clues

[Adrian1979]

I have a straight table which shows the sum of a field by date, and sorted by date.

I want to show if the current value is higher or lower than the proceeding date value using the visual clues - is this possible?  I want it to go green if it higher or red if it is lower.

[chrismarlow]

Hi,

Maybe use something like this in Background color box;

=if(RowNo()=1,null(),
if(above(sum(mea))>sum(mea),
Red(),Green())
)

Cheers,

Chris.