View original (French)

Cell Color in OpenOffice Calc

Marco Paulo -  
 TR -
Hello,

Here, I would like to change the background color of a cell based on a condition equal to (a word), but it doesn't work; I tried with numbers and it works.
Is it possible to do this with OpenOffice Calc? If so, please give me the solution.
I know that it works with Excel.

I am working on Linux for OpenOffice Calc.

Thank you in advance
Configuration: Windows XP Firefox 2.0.0.3

5 answers

  1. marco paulo
     
    Hi,

    Thank you for your response. I did everything as mentioned above, but I forgot the quotes at the ends of the word ("cat").

    For those who have the same problem:

    To change the background color of a cell based on a word or number condition, you need to follow the procedure below:

    1.- Go to [Format] -> [Styles and Formatting] -> right click in the [Styles and Formatting] window -> Choose [New] -> Select the [Background] tab in the new window that opens and choose a color (e.g., red), click on the [Manage] tab and give it a name (e.g., red), click [OK], the name should appear in the [Styles and Formatting] window.

    2.- Select a cell or multiple cells according to...

    3.- Go to [Format] -> [Conditional Formatting] -> enter the word "cat" -> choose the cell style (e.g., red) click [OK] and it works.

    NOTE: If you enter cat without the ", it will not work. Conversely, if you follow the same procedure with numbers, you should omit the ".

    Thank you for the response.
    42
    1. Mimosa
       
      THANK YOU THANK YOU ...
      0
    2. W1Baker
       
      I had been searching for a long time and how to do it, and now I have the solution, thank you.
      0
    3. anonimous
       
      just right click< format cells < background choose <color< OK
      0
    4. Happycx
       
      You're welcome!!!
      0
    5. TR
       
      Thank you very much. I hadn’t noticed the quotes issue and was racking my brain. It was tricky because if you don't include them, the alphanumeric value box registers as 'Toto', which doesn’t work, instead of "Toto", which does!
      Another silly trick: I wanted a triple condition of values noted I, II, and III (sorry "I", "II" and "III"!) To prevent the first condition from recognizing the first I from II or III, you need to use the property that if the first condition is true, the conditional formatting stops.
      The trick is to describe them in reverse in the conditional formatting: /if the value is / equal to / "III" / then set the style
      then condition 2: /if the value is / equal to / "II" / then set the style
      and finally condition 3: /if the value is / equal to / "I" / then set the style
      That way, it works correctly.
      Thanks again.
      0