Wednesday, August 11, 2010

Colorize the cell respect to the value

    Using style function with if condition we can do
   

    STYLE(IF(CURRENT()=0;"def";IF(CURRENT()>0;"positive";"negative")))

    Ref : http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_STYLE_function


No comments:

Post a Comment