Skip to Content
0
Former Member
Feb 17, 2009 at 08:56 AM

Exception (colouring cells) in report output based on formula.

7 Views

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.