[Solved] If/else to change background color?

[fxSol]

Ok I now basic of programming and I am used to if/else clauses.
Now I am playing around with numbers and added this formula -

Code: Select all

=IF(D2 > median($D3:$D7))

Which gives me the desired bolean output of TRUE, but what if TRUE set background to "green" else "red"?

[Lupp]

Did you study my answer to your previous post?
Didn't it work?
What do you expect?
Please describe to the needed detail what you want to achieve. Otherwise contributors trying to help are in danger to waste their time.

[Villeroy]

Code: Select all

=STYLE(IF(D2 > median($D3:$D7);"green_cell_style";"red_cell_style")

or use conditional formats which works with constant values as well.

[fxSol]

Wunderbar! Would not have guests it in million jahren! Viele danke!
Its's a big and complex application and to be honest I have not used excel and there is a steep learning curve.
Thanks for helping us mortals out!

Did not know we had a style function , more info here for the mortals -
https://wiki.openoffice.org/wiki/Docume ... E_function

[Lupp]

Well, you can use the STYLE() function to assign a cell style to a cell containing a formula. You cannot use it to apply attributes to cells containing data.
Are you aware of the fact that the cell style assigned by STYLE() will persist changes and deletion of the formula? Removing the STYLE() part from the formula will not afflict the already applied cell style.
STYLE() works compltely different than ConditionalFormat.

[fxSol]

Well, you can use the STYLE() function to assign a cell style to a cell containing a formula. You cannot use it to apply attributes to cells containing data.
Are you aware of the fact that the cell style assigned by STYLE() will persist changes and deletion of the formula? Removing the STYLE() part from the formula will not afflict the already applied cell style.
STYLE() works compltely different than ConditionalFormat.

You must understand that this all is still "greek" for me until I get my hands dirty and learn everything from inside out =)

I have a problem though, value always returns 0 with no cell formatting at all. If I remove the style function, everything works ok. Could it be that on this computer I use Libreoffice and not OpenOffice?
Maybe I need to add "style" called "red" and "green"??

[Villeroy]

You must understand that this all is still "greek" for me until I get my hands dirty and learn everything from inside out =)

Start learning from outside in. Get a good book on spreadsheets. Any Excel book of the 90ies will do. For Calc I would recommend the documentation on the websites of OpenOffice or LibreOffice respectively. Take some time. This will be your first programming language. Learn systematically about data entry, sheet navigation, types of values, function arguments, relative and absolute addressing, cell styles. Conditional formatting combines more than one concept.
Then read this topic again and everything will be crystal clear.