Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Conditional Formatting - Colour Scale.

Libre Office Version:

I need to colour code cells based on the the key below. 1 = Green 2 = Gold 3 = Blue 4 = Red 5 = Brown 6 = Light green 7 = Lime 8 = Yellow 9 = Dark Purple

Any number will be entered into multiple cells and calculations done based on the cell content. The colours are for others to view for reporting purposes. Can the numbers also be changed to reflect the colour they represent so they are not visible once entered and the corresponding colour is used to populate the cell?