Confidional formatting with formula

[andreaprina]

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

[Gaffer]

I 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 format

[JohnSUN]

You have a lot of possibilities to solve your problem
See attached file ExamplesOfFormatting.ods