Hi Gurus,
I want to colour my cells in report output. But this coloring is not so simple. It has to be done based on a formula.
Lets say i have material in rows and sales value by period in columns.
.......................Jan'08......Feb'08.......Mar'08.....Apr'08
Material A...........100..........120............105.........140
If Feb'08 values is greater than 0,02*Jan'08 value than ---> Feb'08 has to be coloured as green. etc.
Is it possible to define such a rule for the exception?
Thanks
S.P.