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 <[email protected]> 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: [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
