Apache OpenOffice Community Forum

Posted: **Sat Feb 19, 2022 1:05 am**

Does anyone know how I can make openoffice calc do the conditional formatting that google spreadsheets can? I can select some number of cells, conditional formatting, and it lets me format the cells to a color gradient based on the values being high or low or somewhere in the middle, automatically with no fiddling of setting colors to certain value breakpoints. I can't seem to figure out how to do that with openoffice calc. Anyone know?

Posted: **Sat Feb 19, 2022 5:11 am**

There is no built in way to have a color gradient as conditional formatting in Calc as far as I know.

Posted: **Sat Feb 19, 2022 7:47 am**

There is some similar feature inthe LibreOffice Calc.

: Click on the image for a better view.

Apache OpenOffice Community Forum

[Solved] Format cells with a "color scale" like google docs?

[Solved] Format cells with a "color scale" like google docs?

Re: How do I format cells with a "color scale" like google d

Re: How do I format cells with a "color scale" like google d