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.
Take a look to this extension:
may be is what you are looking for.
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.
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.
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.