Results 1 to 7 of 7

Thread: *Office anyone?

  1. #1

    Default *Office anyone?

    Dear all,
    I would like to ask Libreoffice and Openoffice users.
    In calc I have written in some cells (quite a lot) the values
    YES and NO

    I would like to "paint" the YESes with green and the NOs with RED.
    That is why I have used conditional formating
    a.First I selected the cells with the YESes and the NOs
    b. Then I selected Format->Conditional Formating
    c. I clicked in Condition 1 , Cell values is equal to 'YES' and I selected the style with the green font color
    d. then I clicked in Condition 2, Cell values is equal to 'NO' and I selected the style with the red font color
    e. Then I pressed ok but it seems that only the first condition is applied and only in some of the cells and in a wrong manner. Some Yes and No turn green which is of course wrong.

    I have also changed the condition from 'YES' to YES and from 'NO' to NO. I also made the cells format to be Text but this also did not help

    Could you please suggest me what I might be doing wrong in that procedure?

    I would like to thank you for your help
    B.R
    Alex

  2. #2
    PeeGee NNTP User

    Default Re: *Office anyone?

    On 16/11/11 08:46, alaios wrote:
    >
    > Dear all,
    > I would like to ask Libreoffice and Openoffice users.
    > In calc I have written in some cells (quite a lot) the values
    > YES and NO
    >
    > I would like to "paint" the YESes with green and the NOs with RED.
    > That is why I have used conditional formating
    > a.First I selected the cells with the YESes and the NOs
    > b. Then I selected Format->Conditional Formating
    > c. I clicked in Condition 1 , Cell values is equal to 'YES' and I
    > selected the style with the green font color
    > d. then I clicked in Condition 2, Cell values is equal to 'NO' and I
    > selected the style with the red font color
    > e. Then I pressed ok but it seems that only the first condition is
    > applied and only in some of the cells and in a wrong manner. Some Yes
    > and No turn green which is of course wrong.
    >
    > I have also changed the condition from 'YES' to YES and from 'NO' to
    > NO. I also made the cells format to be Text but this also did not help
    >
    > Could you please suggest me what I might be doing wrong in that
    > procedure?
    >
    > I would like to thank you for your help
    > B.R
    > Alex
    >
    >


    A problem I found is that, when setting a conditional format, the format
    may be applied to the cell directly.

    Try selecting the row/column and formatting the cells to the normal
    settings via "Format -> cells -> font effects".

    --
    PeeGee

    MSI m/b 870-C45, AMD Athlon II X3 445, 4GB, openSUSE 11.3/11.2 x86_64
    dual boot + XP Home in VBox
    Asus m/b M2NPV-VM, AMD 64X2 3800+, 2GB, openSUSE 11.3 x86_64/XP Home
    dual boot
    Acer Aspire 1350, AMD (M)XP2400+, 768MB, openSUSE 11.4/XP Home dual boot
    Asus eeePC 4G (701), Celeron M353, 2GB, openSUSE 11.3 on SSD

  3. #3

    Default Re: *Office anyone?

    Hi,


    also if the value to compare is a text, don't forget to put it between a double quote (") at each end, not single quotes.

    HTH
    LEnwolf

  4. #4
    Join Date
    Dec 2008
    Location
    Athens
    Posts
    296

    Default Re: *Office anyone?

    The most important fact to consider is, that you values are indeed consistent, meaning that all YES are text string YES and all NO are text string no. A good workaaround is to put the values (YES) and NO in two additional cells and define your conditional format with reference to the.

    Moreover, I would suggest to search for answers to such questions here:
    Openoffice community forum
    Main box: OpenSuse 12.3)/KDE 4.10 64bit
    Older Box: OpenSuse 12.2/KDE 4.8.5 64bit (my mediabox)
    Laptop: Debian Wheezy/KDE 4.8.4 64bit

  5. #5
    Join Date
    Dec 2008
    Location
    Athens
    Posts
    296

    Default Re: *Office anyone?

    Again, with less spelling errors:

    The most important fact to consider is, that your values are indeed consistent, meaning that all YES are "text string YES" and all NO are "text string NO". A good workaround is to put the values YES and NO in two additional cells and define your conditional format with reference to them.
    Main box: OpenSuse 12.3)/KDE 4.10 64bit
    Older Box: OpenSuse 12.2/KDE 4.8.5 64bit (my mediabox)
    Laptop: Debian Wheezy/KDE 4.8.4 64bit

  6. #6

    Default Re: *Office anyone?

    Quote Originally Posted by lenwolf View Post
    Hi,


    also if the value to compare is a text, don't forget to put it between a double quote (") at each end, not single quotes.

    HTH
    LEnwolf
    That was the solution!! Great

  7. #7

    Default Re: *Office anyone?

    Glad it worked!

    Lenwolf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •