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

ssateneth · Post by **ssateneth** » 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?

Post by **FJCC** » 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.

Post by **Zizi64** » Sat Feb 19, 2022 7:47 am

There is some similar feature inthe LibreOffice Calc.

: Click on the image for a better view.

[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