Date: prev next · Thread: first prev next last
2024 Archives by date, by thread · List index


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 formatting LO sets 
it automatically).

Succes

I could've sworn that I had tried that, but I guess not.

It works - thanks!


Op 25 mei 2024, om 14:20 heeft Paul Goyette <paul@whooppee.com> het volgende geschreven:

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 "sheet.$row$column", apply format to the entire range
        a-N:j-N

Is this possible?


+---------------------+--------------------------+----------------------+
| Paul Goyette (.sig) | PGP Key fingerprint:     | E-mail addresses:    |
| (Retired)           | 1B11 1849 721C 56C8 F63A | paul@whooppee.com    |
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoyette@netbsd.org  |
| & Network Engineer  |                          | pgoyette99@gmail.com |
+---------------------+--------------------------+----------------------+

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



!DSPAM:6651f84817981359412487!



+---------------------+--------------------------+----------------------+
| Paul Goyette (.sig) | PGP Key fingerprint:     | E-mail addresses:    |
| (Retired)           | 1B11 1849 721C 56C8 F63A | paul@whooppee.com    |
| Software Developer  | 6E2E 05FD 15CE 9F2D 5102 | pgoyette@netbsd.org  |
| & Network Engineer  |                          | pgoyette99@gmail.com |
+---------------------+--------------------------+----------------------+

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.