Ask Your Question

confidional formatting with formula [closed]

asked 2012-12-09 20:26:04 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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 ?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 12:45:10.626982


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

Gaffer gravatar imageGaffer ( 2012-12-09 22:56:43 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-12-10 10:04:47 +0100

JohnSUN gravatar image

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

edit flag offensive delete link more

Question Tools


Asked: 2012-12-09 20:26:04 +0100

Seen: 101 times

Last updated: Dec 10 '12