Ask Your Question

Revision history [back]

Another workaround is to Update the style with a color

Steps

1) Define a new Style with any color. In this case, we leave it at "No fill" because we will be changing it later

default color

2) Set the new it to a cell. In this case we set it to an entire row.

image description

3) Change the color of the cell to the color you want to set to the Style that is not available in the palette. In this case we set it to 150, 150, 150 in RGB.

image description

4) The color of only that cell will change

image description

5) Finally, while positioned it that cell, click on "Update Style" to update the color of the style.

image description

6) The color has been asigned to your Style and all the cells with said style have been updated. In this example, the whole row changed color.

image description

Another workaround is to Update the style with a color

Steps

1) Define a new Style with any color. In this case, we leave it at "No fill" because we will be changing it later

default color

2) Set the new it Style to a cell. In this case we set it to an entire row.

image description

3) Change the color of the cell to the color you want to set to for the Style that is not available in the palette. Style. In this case we set it to 150, 150, 150 in RGB.

image description

4) The color of only that cell will change

image description

5) Finally, while positioned it that cell, click on "Update Style" to update the color of the style.

image description

6) The color has been asigned assigned to your Style and all the cells with said style have been updated. In this example, the whole row changed color.

image description