LO Version: 220.127.116.11
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3
OS: Ubuntu 16.04 LTS
I have a Calc sheet where I want the formatting of a given row to be dependent on the value of a specific cell within that row. For some reason, I can get this to happen with the STYLE() formula, but not with the Conditional Formatting setting (which would be preferable so that I don’t have to slap a STYLE() on every single row).
The specific cell being used to determine the formatting has text content restricted by a List criteria: the contents can either be “Active” or “Inactive”. If the cell’s contents are “Inactive”, I want the “Inactive” formatting style to be applied to the row. If the contents are “Active”, I want the “Active” formatting style applied.
If I apply the following STYLE() formula to a cell within the row, it executes just fine and behaves as expected:
However, if I go to Conditional Formatting and use the following details:
Condition 1 Formula is C4="Inactive" Apply style Inactive Cell Range: A4:Z4
Condition 2 Formula is C4="Active" Apply style Active Cell Range: A4:Z4
Nothing happens. No formatting is applied, and toggling the value of C4 doesn’t make a difference.
I’ve tried setting “Formula is” to
C4=="Inactive", and anything else I can think of, but nada. What’s going on here?