Ask Your Question

Can color scale formatting be customized?

asked 2013-07-31 23:11:19 +0200

Erulora gravatar image

Is it possible to change the default colors for the color scale conditional formatting from red/green/blue to something else?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-04-16 17:48:12 +0200

endolith gravatar image

The default red-green-blue is ugly and hard to read:

Ugly color scale

These are the RGB values used by Excel, which are much better:

green   99 190 123
yellow 255 235 132
red    248 105 107

To make these selectable in the Color Scales box, you must first add them to your palette. Go to Tools → Options → Colors. Enter the values and press Add to add a new color:

Color editing

Then in the Conditional Formatting box, you can select these colors: Conditional Formatting dialog

and now your color scale will look much better:

better colorscale

(Now if you meant to change these to the default every time you open the Conditional Formatting window, I don't know how to do that, but this is what I was trying to do.)

edit flag offensive delete link more

answered 2013-08-02 12:16:01 +0200

oweng gravatar image

Have you tried creating a template (with the required default colours) and setting this template as the default? In this way each new Calc document should use the newly defined default colours.

edit flag offensive delete link more


How would you do this?

endolith gravatar imageendolith ( 2015-04-10 21:27:07 +0200 )edit

Help page on changing default template here.

oweng gravatar imageoweng ( 2015-04-11 09:53:23 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2013-07-31 23:11:19 +0200

Seen: 1,290 times

Last updated: Apr 16 '15