none
Want to Change Background color of the Cell by comparing two column values

    Question

  • If the Value of Sales Amount in First Row is Greater than the value in Second Row then Change the Background Color of the Second row to "Red" if the Value is less than then change to "Green". Like this it should compare 2nd and 3rd row and 3rd and 4th row so on.

    Like this i've to change the color for n columns and the columns which are added in future.

    Date Sale
    01/07/2005 14477.3382
    02/07/2005 13931.5200
    03/07/2005 15012.1782
    04/07/2005 7156.5400
    05/07/2005 15012.1782
    06/07/2005 14313.0800
    07/07/2005 7855.6382
    08/07/2005 7855.6382
    09/07/2005 20909.7800
    10/07/2005 10556.5300

    i.e the Sales Value in first row should Contain the default background Color and in second row by comparing the first row value  is decreased  so the the BG Color must change to 'Red' and by comparing the 3rd and 2nd row values 3 rd row is increased sho it should change to 'Green' and if the values are equal then' yellow'

    OR 

    Like Below Matrix Report i have Two Reports

    English Month Name 2005           2006                       2007                                 2008
    January                                      596746.5568      438865.1718               1340244.9500
    February                                      550816.6940      489090.3356               1462479.8300
    March                                      644135.2022       485574.7923               1480905.1800  
    April                                              663692.2868       506399.2654                1608750.5300
    May                                              673556.1978       562772.5645                1878317.5100
    June                                             676763.6496        554799.2281                1949361.1100
    July                          473388.1630      500365.1550        886668.8400                   50840.6300
    August                  506191.6912      546001.4708        847413.5100
    September          473943.0312       350466.9912        1010258.1300
    October                513329.4740     415390.2333     1080449.5800
    November        543993.4058    335095.0887    1196981.1100
    December                 755527.8914    577314.0002    1731787.7700

    In One Report I need to Compare the Values Month wise i.e. "2006 Jan-2006 Feb"and Change The BG Color and i Another report i need to Compare the Values Year Wise i.e. "2006 Jan-2007 Jan"and change the bg Color of a Cell.

    if the report is  table report then what will be the approach.

    Saturday, March 15, 2014 9:49 AM

All replies