Ask Your Question

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

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

Yohane gravatar image

updated 2020-08-08 10:37:54 +0100

Alex Kemp 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

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

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 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

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

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


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

Seen: 1,062 times

Last updated: Mar 12 '14