Ask Your Question

Multi comparison in conditional formatting

asked 2015-04-23 18:24:19 +0200

Nigel gravatar image

Hello I trying to get the following conditional formatting in libreoffice calc:

If A1 = A2 and A3 and A4 then format A1

I tried with array : format => conditionnal formatting => formula is: A1={A2;A3;A4} but this does not work.

Any idea how to solve this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-23 19:13:47 +0200

karolus gravatar image

Try formula (A1=A2)*(A1=A3)*(A1=A4)

edit flag offensive delete link more


thank you, it works

Nigel gravatar imageNigel ( 2015-04-23 20:01:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-23 18:24:19 +0200

Seen: 52 times

Last updated: Apr 23 '15