Bug 35433

Summary:	Calc: Color result number based on ranges
Product:	LibreOffice	Reporter:	Rosalie Dieteman <miros1>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	enhancement	CC:	jumbo4444
Priority:	medium
Version:	unspecified
Hardware:	Other
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Rosalie Dieteman 2011-03-18 13:45:02 UTC

I'd like to be able to set the color of a cell's text based on the value, similar to the existing "highlight if less than 0" feature.

For example, if I have a calculated cell that will have integer values from 0 to 10:
0-3 red
4-7 yellow
8-10 green

Comment 1 Laurent Balland 2011-08-24 12:54:48 UTC

Hello,

Your request concerns Calc and not Math. Then I changed the Component of this bug.

The solution of your problem should be "Conditional Formatting" in Format menu. So this feature already exists. You may close this issue.

Comment 2 Björn Michaelsen 2011-12-23 11:49:47 UTC

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

Comment 3 Laurent Balland 2011-12-26 12:59:41 UTC

Hello,

I closed the bug as it looks like Format > Conditional Formatting.