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 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 | p...@whooppee.com|
| Software Developer | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org |
| & Network Engineer | | pgoyett...@gmail.com |
+-+--+--+
--
To unsubscribe e-mail to: users+unsubscr...@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 | p...@whooppee.com|
| Software Developer | 6E2E 05FD 15CE 9F2D 5102 | pgoye...@netbsd.org |
| & Network Engineer | | pgoyett...@gmail.com |
+-+--+--+
--
To unsubscribe e-mail to: users+unsubscr...@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
