We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc: Automatic Cell Coloring? [closed]

asked 2020-02-05 11:12:39 +0200

nuohntyv gravatar image

updated 2021-06-02 23:51:50 +0200

Alex Kemp gravatar image

I do not know, what I have changes, but some of my columns are somehow automatically colored. Calculated strings are green, some numbers and dates in blue. If I change the content of a cell, the colour changes as well. I cannot change the colors of those cells via the "Font Color" button, but I can change the background. I am using on Win7.

Any help please?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-06-02 23:51:57.617326

2 Answers

Sort by » oldest newest most voted

answered 2020-02-05 11:17:10 +0200

Opaque gravatar image

updated 2020-02-05 11:17:48 +0200


probably you have ticked View -> [x] Value Highlighting (accidentally clicked CTRL+F8?).

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more

answered 2020-02-05 11:20:04 +0200

nuohntyv gravatar image

That seems to be the case. Merci beaucoup!

edit flag offensive delete link more


Please do not use Add Answer if you actually don't answer a question but commenting an answer. Please use add a comment for that purpose. Thanks in advance …

Opaque gravatar imageOpaque ( 2020-02-05 11:22:48 +0200 )edit

Question Tools

1 follower


Asked: 2020-02-05 11:12:39 +0200

Seen: 73 times

Last updated: Feb 05 '20