ac senthilkumar's blog

________________________________________________________________________________________

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


Posted by Senthil kumar at 8/11/2010 03:20:00 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Open Office

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

  • Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
  • Err: LD_LIBRARY_PATH not set for normal user except root
  • BigBlueButton: Changing of port number from 80 to new one
  • Convert unix timestamp to PostgreSQL timestamp
  • Postgresql 9.x to 8.x restore issue with bytea field contains hex values
  • Err: Couldn't open header file ...
  • Restore plain dump file using console
  • Err: Install the XSL module (recommended for Propel) ...
  • Wordpress to Blogger migration too easy..
  • Err: Wrong Datatype (#Value will be displayed)

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Search in this Blog ...

Labels

  • Linux (49)
  • Errors (44)
  • PostgreSQL (44)
  • Ubuntu (38)
  • PHP (34)
  • How to (33)
  • Java Script (15)
  • Tips (15)
  • Apache (11)
  • Regular Exp (11)
  • Drupal (9)
  • Open Office (9)
  • CSS (6)
  • Flash Builder for PHP (6)
  • Symfony (5)
  • Web (5)
  • Windows (5)
  • Eclipse (3)
  • Programming (3)
  • Advanced SQL (2)
  • Firefox (2)
  • Android (1)
  • Chrome (1)
  • HipHop (1)
  • Java (1)
  • Links (1)
  • MySQL (1)
  • Softwares (1)
  • Utilities (1)

Followers

Senplusone. Simple theme. Powered by Blogger.