[libreoffice-users] Conditional Formatting Borders on cell that contains text

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