Ask Your Question

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

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

chtfn gravatar image

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

tohuwawohu gravatar image

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.

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 2015-10-15 05:08:20.276840

2 Answers

Sort by » oldest newest most voted

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

m.a.riosv gravatar image

Take a look to this extension: may be is what you are looking for.

edit flag offensive delete link more


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.

chtfn gravatar imagechtfn ( 2012-03-16 04:15:10 +0200 )edit

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

drone27of1 gravatar image

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.

edit flag offensive delete link more


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.

chtfn gravatar imagechtfn ( 2012-03-16 04:22:42 +0200 )edit

Question Tools


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

Seen: 1,341 times

Last updated: Feb 26 '12