Add Background Colour etc to Random Cells in an Apache Open Office Calc (Spreadsheet)
(This blog was written for versions of OpenOffice up to Version 3.4.0)
If the icon is not there -
Click on the down arrow on the bar at the end of the standard toolbar and from the Drop down > click Visible Buttons > find the icon for 'format paintbrush' and click on it to make it active on the toolbar.
On the Calc document > Select a Cell to format the background colour > Format > Cells > and from (Format Cells Window) > Background > select colour > Click OK. (This fills chosen cell with colour)
With the (coloured) Cell selected > double click the 'format paintbrush' icon on the toolbar. The cursor will change to a paint pot pouring paint. Select any cell on the spreadsheet > left click to add the colour.
Repeat on other cells to fill with this colour > Press the Escape key on the Keyboard to finish adding colour (or double click the format paintbrush icon on the tool bar)
This action may be repeated to choose another colour to add to various other cells in the Calc document. Press the Escape key or double click the format paintbrush icon to return to working on the spreadsheet.
The colour may be added to a cell before or after text has been written in the cell.
Any of the formatting options in the Format Cell Window can also be applied to the original cell formatting such as Borders, Font, Font Effects, Alignment etc and will be carried over to other cells when the format paintbrush is used.