Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 10 Dec 2012 10:04:47 +0100confidional formatting with formulahttps://ask.libreoffice.org/en/question/8831/confidional-formatting-with-formula/i need to formatting the cell with formula in differt way
i put this formula =SE(I9<0;"ORDINA";"OK") and i want to put different formatting with "ordina" and "ok"
i tried with conditional formatting putting or ordina or formula but it'doesn't work
anyone could suggest a solution ?
thanks
Sun, 09 Dec 2012 20:26:04 +0100https://ask.libreoffice.org/en/question/8831/confidional-formatting-with-formula/Comment by Gaffer for <p>i need to formatting the cell with formula in differt way</p>
<p>i put this formula =SE(I9<0;"ORDINA";"OK") and i want to put different formatting with "ordina" and "ok" </p>
<p>i tried with conditional formatting putting or ordina or formula but it'doesn't work</p>
<p>anyone could suggest a solution ?</p>
<p>thanks</p>
https://ask.libreoffice.org/en/question/8831/confidional-formatting-with-formula/?comment=8836#post-id-8836I am not familiar with the SE() function. So you mean if()? This looks like a requirement for conditional format by value. for condition 1 where value = ORDINA use one formatting. For condition 2, where value = OK, use a different formatSun, 09 Dec 2012 22:56:43 +0100https://ask.libreoffice.org/en/question/8831/confidional-formatting-with-formula/?comment=8836#post-id-8836Answer by JohnSUN for <p>i need to formatting the cell with formula in differt way</p>
<p>i put this formula =SE(I9<0;"ORDINA";"OK") and i want to put different formatting with "ordina" and "ok" </p>
<p>i tried with conditional formatting putting or ordina or formula but it'doesn't work</p>
<p>anyone could suggest a solution ?</p>
<p>thanks</p>
https://ask.libreoffice.org/en/question/8831/confidional-formatting-with-formula/?answer=8852#post-id-8852You have a lot of possibilities to solve your problem
See attached file [ExamplesOfFormatting.ods](/upfiles/13551302688255964.ods)Mon, 10 Dec 2012 10:04:47 +0100https://ask.libreoffice.org/en/question/8831/confidional-formatting-with-formula/?answer=8852#post-id-8852