Ask Your Question
0

Is there a way to colour a series of cells with shaded tones?

asked 2012-02-24 15:53:03 +0200

UbuntuBrisbane gravatar image UbuntuBrisbane flag of Australia
121 2 3 13
http://ubuntubrisbane.wor...

updated 2012-08-12 13:57:20 +0200

tohuwawohu gravatar image tohuwawohu flag of Germany
1812 13 40

Hi there! I would like to know if there is a way to select a few cells and simply give them a shaded background colour at once? For example, 10 cells with 10 different shades of green, from lightest to darkest.

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted
1

answered 2012-02-26 01:29:52 +0200

mariosv gravatar image mariosv flag of Spain
4749 20 46

Take a look to this extension: http://aoo-extensions.sourceforge.net/en/project/escaladecolores may be is what you are looking for.

link delete flag offensive edit

Comments

Cheers! This is a great extension. Works like a charm on LO 3.5. Only thing is that it works only for cells that contain data. Would be great to have it translated into English (this version is in Spanish), and added in the LO extensions website.

UbuntuBrisbane ( 2012-03-16 04:15:10 +0200 )edit
0

answered 2012-02-24 16:04:17 +0200

drone27of1 gravatar image drone27of1 flag of Canada
216 6

Press F11 to bring up the Styles and Formatting. Create 10 styles with different greens. Highlight the cells you want and double-click the style.

link delete flag offensive edit

Comments

Thanks for your answer. The problem is the limited choice of colours. Mariosv's solution makes it a lot easier, with any number of shades.

UbuntuBrisbane ( 2012-03-16 04:22:42 +0200 )edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-02-24 15:53:03 +0200

Seen: 236 times

Last updated: Feb 26 '12