cell colors not working

When I try to set cell color, nothing happens

Your sparse information hardly allows for a good answer.

  • Please edit your question and add any missing information. Thank you.

  • Which operating system and which LibreOffice version do you use?

  • Please describe the individual steps, how you proceed.


Remember that no potential helper can look over your shoulder here.

@scooterman-psl, Please, choose retag (below your question), delete common, type calc or write, as applicable, and press Enter twice. Thanks. The common tag is for all LibreOffice modules (Writer, Calc, Draw, etc.).

How are you trying to set color? With the Background Color button (a bucket icon)? Or choosing menu Format, etc.


Press edit below your question to add more information. Add Answer is reserved for solutions.

Additionally: Where does your sheet come from? Does the sheet use Conditional Formatting with conditions being met on those cells you can’t change the color (by the way: Which color - text, background, borders, shadows,…?)?

Don’t know what you mean. My spread sheet cell colors just disappeared & now I can’t get any colors for cells.

My spread sheet cell colors just disappeared

  • Are some toolbar Icons disappeared? Then you can switch ON them again. Just use the View - Toolbars - (Formatting) or the Tools - Customize menu item.
  • Or the colors disappeared from the inserted characters and results; and are there blue, green, or black values only?? Then (maybe) you switched ON accidentally the View - Value highlighting feature.