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 réponses

Réponse 1 / 5
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
Mimosa
 
THANK YOU THANK YOU ...
0
W1Baker
 
I had been searching for a long time and how to do it, and now I have the solution, thank you.
0
anonimous
 
just right click< format cells < background choose <color< OK
0
Happycx
 
You're welcome!!!
0
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