Has color replacement functionality been removed from Calc?

[tsteele93]

I have a document with different words that I would like to change the font to a specific color. For example, water would become water with a blue colored font… It appears that LibreOffice Calc had this functionality in 2012-2016+ but I cannot find it now.

Is this possible anymore? I was hoping it would be as simple as Find and Replace and search for the word (water) and have it replace that word with the font in a different color (or even perhaps a different font AND color.)

Thanks for any help you can provide. If it was removed, is there any way to find out why and to see if there is a way to ask for it to be re-instated? Thank you.

[LeroyG]

@tsteele93

2012-2016+

Versions 3.5 – 5.3.

I suppose that it never was possible with Calc, but with Writer.

With Calc (at least in version 24.8), you can find all cells that contain “water”, then you must apply the font color (or cell style), but this will apply to all the cell content.
You can’t find within a cell while in edit mode: Find Next will jump to the next cell with “water”.

As a workaround, you can paste the cell range in Writer (you will get a table), there you can find all and apply color, match the destination font name and font size, then copy and paste in Calc.

[Wanderer]

@tsteele93

It appears that LibreOffice Calc had this functionality in 2012-2016+ but I cannot find it now.

Filter and sort by clor is a later addition.

How can i search for colored cells in libreoffice calc

Filtering possible since 7.2 in Calc https://wiki.documentfoundation.org/ReleaseNotes/7.2 Additional sort by color in filter in 7.6: https://wiki.documentfoundation.org/ReleaseNotes/7.6

A general method for replacement was to find all occurencies of something, so all places are marked, and then change the style for everything marked not with the find/replace diaogue, but by directly changing the style.
.
Better is to avoid this by using semantic styles directly. Then all you need is changing the style…

[Regina]

If you want to style the entire cell and not only part of the cell content, then you can define a condition. First define the cell style to be applied, then mark the to be effected cell range and then use Format > Conditional.