Apache OpenOffice Community Forum • [Solved] Set cell's colour based on its value - (View topic)

Page 1 of 1

[Solved] Set cell's colour based on its value

Posted: Thu Sep 25, 2025 9:34 am

by KISSMAD

Is it possible to have a cell calculation that if the answer is below 28 then the answer is bold and the colour is red?

Re: Cell Calculation Colour

Posted: Thu Sep 25, 2025 10:02 am

by Lupp

This is a standard use-case of conditional formatting.
See help page.
Also see attachment

aoo_113096_ConditionalFormatting.ods: (39.06 KiB) Downloaded 13 times

[SOLVED] Re: Cell Calculation Colour

Posted: Thu Sep 25, 2025 2:32 pm

by KISSMAD

Thank you Lupp

It took a little while to get it working properly but I got there.