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 > Op 25 mei 2024, om 14:20 heeft Paul Goyette <[email protected]> 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 | [email protected] | > | Software Developer | 6E2E 05FD 15CE 9F2D 5102 | [email protected] | > | & Network Engineer | | [email protected] | > +---------------------+--------------------------+----------------------+ > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
