Ask Your Question

if cell = value color BG

asked 2017-11-12 14:45:58 +0200

paparucino gravatar image

Hi all, Im a noob user of libreoffice so pls be patient. Situation Cell A1 = value1, Cell B1 = value2, Cell C1 = IF((value2-value1=0),"0","X") What I would like: if result = 0 "color the baground with green, otherwisw red I tried with Conditional formatting (I really know it very little) and the max I got was a 0 or a X without any color

Any idea, suggestion?

Thank you in advance papa

edit retag flag offensive close merge delete


@paparucino: Please click ✔ to mark the answer as correct.

Jim K gravatar imageJim K ( 2017-11-13 21:23:51 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-11-12 15:15:47 +0200

librebel gravatar image

Hello @paparucino,

Please try the following formula in cell C1:

= IF(A1=B1,"0" & T(STYLE("Good")),"X" & T(STYLE("Bad")))

If your locale instead uses the semicolon as argument separator, the formula becomes

= IF(A1=B1;"0" & T(STYLE("Good"));"X" & T(STYLE("Bad")))

HTH, lib

edit flag offensive delete link more


It works. Thank you so much!!!


paparucino gravatar imagepaparucino ( 2017-11-12 15:19:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-12 14:45:58 +0200

Seen: 33 times

Last updated: Nov 12 '17