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

Discuss the spreadsheet application
Locked
KISSMAD
Posts: 14
Joined: Thu Oct 23, 2008 2:13 am

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

Post 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?
Last edited by MrProgrammer on Thu Sep 25, 2025 6:40 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]; Edited topic's subject
Open Office 4. Windows 11 and 7
Top
User avatar
Lupp
Volunteer
Posts: 3716
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Cell Calculation Colour

Post 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 8 times
On Windows 10: LibreOffice 25.2.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Top
KISSMAD
Posts: 14
Joined: Thu Oct 23, 2008 2:13 am

[SOLVED] Re: Cell Calculation Colour

Post by KISSMAD »

Thank you Lupp

It took a little while to get it working properly but I got there.
Open Office 4. Windows 11 and 7
Top
Locked

Return to “Calc”