Re: [libreoffice-users] Calc- find & replace with specific formatting

At 18:23 18/04/2020 -0400, Peter Dutton wrote:
> In Calc I want to find a specific word and replace that word with a 
> bold version of it.

I think this depends on whether the word you refer to is the total 
contents of a cell or just part of it. Formatting in a spreadsheet is 
generally handled on a cell basis, not by character. So although you 
can indeed manually set part of the contents of a cell to, say, bold, 
I don't think there is going to be any way to apply this automatically.

And I don't see any way to achieve what you want as local formatting, 
even if the word is the entire contents of a cell. But there is a workaround:
o Create a cell style including the Bold attribute.
o Select an appropriate cell range - perhaps even an entire sheet or sheets.
o Use Conditional Formatting to apply the Bold cell style to any cell 
whose contents are exactly your word.

I trust this helps.

Brian Barker


--
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