Ask Your Question
0

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

asked 2018-12-05 01:25:43 +0100

patrick.de gravatar image

Hi,

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
1

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

Lupp gravatar image

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

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
AND(ISBLANK(B1);OR(A2="Green";A2="Red"))

edit flag offensive delete link more

Comments

Thank you!

patrick.de gravatar imagepatrick.de ( 2018-12-05 14:05:15 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 23 times

Last updated: Dec 05