Ask Your Question
0

In Calc is there a way to change font colour for certain values? [closed]

asked 2014-03-11 21:10:55 +0200

Yohane gravatar image

For example if a cell number is lower than 70, it should be red, but if 70 or above black?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 07:27:07.721903

2 Answers

Sort by » oldest newest most voted
1

answered 2014-03-12 18:11:51 +0200

ahamedck gravatar image

please go through the help file regarding format codes where in we can see the conditional formatting of the values please see the following link https://help.libreoffice.org/Calc/Applying_Conditional_Formatting we can also use the [BLUE][<70]#0 ;[RED][>70]#0 ;[BLACK]#0 in the format---> cells ---> Numbers tab --->Numbers category ---> format code

edit flag offensive delete link more
0

answered 2014-03-11 23:24:09 +0200

David gravatar image

There is some documentation for this scenario. See also a previous Q&A which might also supply some relevant hints. (It's a start, anyway!)

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-03-11 21:10:55 +0200

Seen: 683 times

Last updated: Mar 12 '14