Re: [libreoffice-users] Help with conditional formatting (Calc)

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