Ask Your Question

Conditional format -> formula is -> multiple arguments? [closed]

asked 2018-12-05 01:25:43 +0200 gravatar image

updated 2020-08-09 20:13:29 +0200

Alex Kemp gravatar image


I want to apply conditional formatting to a cell with "Formula is", but use two arguments.

I.e. I want to format the target cell, A1, if B1 is empty (for this I use ISBLANK(B1)) and if A2 contains either the text "Green" or "Red".

I've tried various ways to combine arguments (&, &OR&, OR, ; etc.), but couldn't make it work. Example: ISBLANK(B1)&A2="Green"OR"Red"

Many thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-12-06 22:17:25.281828

1 Answer

Sort by » oldest newest most voted

answered 2018-12-05 02:15:06 +0200

Lupp gravatar image

updated 2018-12-05 16:52:23 +0200

Formulae used in ConditionalFormatting need to be composed in the same way as if used in a spreadsheet cell (except the leading "="). In fact you should "develop" and check the formula (if not obvious) in a cell, and then copy it, and paste it into the respective line in the CF dialogue.
AND, OR aren't operators in Calc, but functions accepting an arbitrary number of parameters. Your formula should read

edit flag offensive delete link more


Thank you! gravatar ( 2018-12-05 14:05:15 +0200 )edit

Question Tools

1 follower


Asked: 2018-12-05 01:25:43 +0200

Seen: 732 times

Last updated: Dec 05 '18