On Sat, 25 May 2024, Rob Jasper wrote:
Paul,
Yes, you should use a formula as condition.
To use a formula as condition:
Go to Format -> Conditional -> condition -> More rules -> formula:
$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the
conditional
Paul,
Yes, you should use a formula as condition.
To use a formula as condition:
Go to Format -> Conditional -> condition -> More rules -> formula:
$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the
conditional formatting LO sets it automatically).
Succes
I've read the docs, and tried several ways, but I cannot seem to
get it right.
I'd like to apply conditional formatting to a group of cells, based
on the value of one cell in the group. Something like
In cell range a5:j10, if the row-N column-C entry is equal
to