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

  • Refresh system settings from sysctl.conf without restart Linux
  • Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
  • Err: Retaining/populating of the value does not change in Drupal while edit form
  • To reset MySQL root password
  • Get Distinct values from comma separated values
  • Err: Can't include or not working
  • Advanced SQL to fetch entire year deatail records
  • quicktime demuxer not found in Ubuntu 11.10
  • Err : Child node has no properties while handling AJAX response XML
  • List file names with modified time stamp customized

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.