[Solved] More than 3 conditional formats

[dante99]

Hy alll.

i am new user on open office end i need some help with the following,
i need to make a multiple conditional formatting:

value below 80 red background
value 80 to 85 other background color
value 85 to 90 other background color
value 90 to 95 other background color
value 95 to 105 other background color
value 105 to 110 other background color
value higher than 110 other background color

can some one tell me if is possible

thanks

[Villeroy]

can some one tell me if is possible

thanks

Yes, it is.

[Hagar Delest]

To elaborate on previous post, see this one for example: [Solved] Changing color of currency based on their values.

Please read the [Survival Guide for the forum. This was the underlying message of previous post.

NB: split from the initial topic since this problem can be easily fixed without a macro.

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.

[bikehounds]

top result on google comes to this completely unhelpful page. I registered an account only to give a big, sarcastic thank you - that's how obnoxious this answer is. a moderator should delete this entire thread and get it off of google.

[Villeroy]

+1
The mere question IF it is possible was appended in 2012 to a topic of 2008 which described at least 2 methods. Moving this truely stupid question out of its context does not make it more comprehensible.
Today the answer would be: "Install LibreOffice instead of OpenOffice".

[Jeff]

Hello,

Today the answer would be: "Install LibreOffice instead of OpenOffice".

Or install CF+ extension

Regards

[bikehounds]

Thanks, but "install a different program" is equally unhelpful.

I have figured out how to do this, and will put the solution here for future google users so that the title of this thread as "Solved" is actually accurate.

The first step is to create the styles that you want to be able to apply, and name them. There are several ways to do this, the easiest one in my opinion is to style a sample cell the way you want and then create a style from that cell. Instructions for this can be found here:
https://wiki.openoffice.org/wiki/Docume ... new_styles

Once you have your styles created ( I will use the examples Green, Yellow, Red1, Red2, Red3 below), you can create unlimited conditional formatting as follows:

1. Highlight entire range you'd like to format. Drag from the top left to bottom right so that the active cell in the selection is the last cell of the last row.
2. Take note of the letter of the column which you would like to compare the conditional against (in my example I will use Column A)
3. Take note of the row number of the bottom of your selection (in my example I will use row 7)
4. Pull down Format -> Conditional Formatting
5. Change Condition 1 drop down from Cell value is to Formula is

Enter a formula like:

Code: Select all

STYLE(IF($A7="Good";"Green";IF($A7="OK";"Yellow";IF($A7="Bad";"Red1";IF($A7="Worse";"Red2";IF($A7="Worst";"Red3"))))))

Note that each nested IF statement compares cell $A7 - make sure you are using the Column from step 2 with a dollar sign and the row from step 3 without a dollar sign, and make sure you have the correct number of closing brackets.

[RoryOF]

An OpenOffice extension, such as Jeff suggested, is exactly that - an extension to OpenOffice that integrates with it and extends its capabilities; hardly another program. Al you have done is reinvented the wheel.

[bikehounds]

I was specifically referring to the previous post. I do appreciate the link posted by Jeff, however I had already solved it in another way. I'm sorry my posted solution is offensive.

[RoryOF]

Your post was not offensive, and I'm sorry you have read my post as suggesting that. I hadn't realised that your reference was to Villeroy's post, rather than to Jeff's. LibreOffice stems from OpenOffice code and has better support for MS Office formats (albeit, not perfect support); it is under more active development, which can make newer versions of it less stable than the conservative OpenOffice, which is also being developed, but at a slower rate.

Many Forum volunteers, in their attempt to give best advice, will recommend LibreOffice when appropriate; multiple conditional formatting is provided in LibreOffce Calc.

[bikehounds]

Thank you, this info is much more helpful.

Meantime, I don't think it is a bad thing to have a solution for Open Office users posted in the thread where the question was asked.

[Villeroy]

Thanks, but "install a different program" is equally unhelpful.

LibreOffice is not that different. It is the successor to OpenOffice. OpenOffice is almost dead and its "son" or "daughter" has taken over several years ago.

[bikehounds]

I get that, but when someone has a spreadsheet open in a program already installed on their computer and they search for a solution to an acute issue, it will hopefully be helpful for them to have something that gets them rolling in that moment instead of advice to uninstall the program they are actively working in and restart with a new installation. I mean, why have an openoffice forum at all if not to help people with openoffice issues? This whole thread is bizarre.