Rob
Select 1 cell (just take an arbitrary one)
Right click cell and go to “Format cells”
Select tab “borders”
Click “all for borders” (second from left, square)
Click OK
Select from toolbar: Styles -> New Style from Selection
Name the style in the pop-up box (I named it mybox)
Select from toolbar: Format -> Conditional -> Condition
Enter in condition 1:
“Cell value” “is not equal to” “” (empty string)
In range:
A1:XFD1048576 (Or anything you want)
Click OK
That’s all
Success,
Rob
Op 14 sep. 2023, om 04:37 heeft Rob Berridge <ribsnz@gmail.com> het volgende geschreven: 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. I have version 7.5.62(X86_64) Thanks Rob Berride -- 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
-- 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