4

I am trying to apply conditional formatting to an entire row based on two cell values. The style is to be applied only if both cells have a particular value. I tried applying formula of the form:

$A1="Value1" & $B1="Value2"

But it does not apply the style. How to solve this in Libre Office?

Improve this question

1 Answer 1

Reset to default
2

Just use the AND() function to combine the two conditions:

  1. First, use "Formula is..." as criteria;

  2. then enter

    AND($A1="Value"; $B1="Value")

enter image description here

Depending on your local settings, in that formula, you may have to replace the semicolon ; by a comma ,.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .