Ask Your Question

How do I change color of highlighted cell?

asked 2018-02-21 13:20:12 +0100

Astralogic gravatar image

Hi, when I search for text, the cells containing found text are highlighted in blue. I would like to change that color, is there a way to do that?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-02-21 14:53:52 +0100

Lupp gravatar image

updated 2018-02-21 15:03:48 +0100

The cells found (and highlighted) are a selection (internally represented either by a CellRange or by a CellRanges object). As with any selection changes of attributes or e.g. the assignment of a named cell style will apply to the complete selection.

To hard-format the selection you can open the context menu by rightclicking on any of the selected cells and coohose Format Cells... subsequently. From the 'Stylist' (F11) you may assign a cell style. (To be able to search later for the format, prefer to assign a named cell style. Mostly preferrable over direct formatting.)

Addendum: This does not apply to selections across sheets. (You may get them having enabled the option All sheets in F&R.) Multisheet selection will collapse on the rightclick. Cell style assignment will only apply to the part contained in the active sheet.

edit flag offensive delete link more


I think the Q referred to the actual selection (highlight) color, which AFAIK is taken from the system / window manager settings and blended with some luminance, same as for the column/row headers (A,B,.../1,2,...)

erAck gravatar imageerAck ( 2018-02-21 20:22:43 +0100 )edit

You are right. I didn't read thoroughly enough.

Lupp gravatar imageLupp ( 2018-02-22 22:48:24 +0100 )edit
Login/Signup to Answer

Question Tools



Asked: 2018-02-21 13:20:12 +0100

Seen: 244 times

Last updated: Feb 21 '18