https://wiki.documentfoundation.org/images/d/d1/LibreOffice_Calc._Conditional_formatting_guide_EN.pdf
Il 14/09/23 04:22, Rob Berridge ha scritto:
Hi
I am trying to shift a file I have in Excel 2021 to LibreOffice calc.
In it I have a few Conditional Formatting rules. One is that if the
cell is empty there are no borders, but when there is something in the
cell, the range then has borders. I am unsure how to do that in LO
Calc . In Excel >Use formula to determine which cells to format.
:=$B5<>"" .Format values where this formula is true Applies to
=$A$5:$N$40.
Thanks
--
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
