Ask Your Question
0

calc: numbers not showing up in 2 cells... [closed]

asked 2017-03-21 08:02:49 +0200

appreciatethehelp gravatar image

updated 2017-03-21 08:36:01 +0200

C:\fakepath\BUDGET- BASIC- for other's use.ods

Am experiencing a strange phenomenon regarding cells G60 and H60...

if I type a number (without using a formula) into either cell and press enter it will show up.

Also, if (after the current formulae are applied to both cells) the result in either cell is a positive number, it will show up.

But, if (after the current formulae are applied to both cells) the result in either cell is a negative number, it won't show up.

My only theory as to why this is happening is that maybe I somehow set conditional formatting on those two cells to change the font colour, as well as the background colour, to red when the result was below zero, thus making the font "invisible". However, I checked the conditional formatting on those two cells and could only find conditional formatting to make the cell's background green when the resulting number is positive, or red when when the resulting number is negative. Also I don't recall setting conditional formatting for font colour. I originally wanted to (instead of changing the background colour), but couldn't figure out how.

Am a little perplexed… any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-03-21 12:48:33.457750

1 Answer

Sort by » oldest newest most voted
1

answered 2017-03-21 08:11:47 +0200

pierre-yves samyn gravatar image

Hi

Untick (or other change in the colors...): FormatCellsNumbers tab▸Negative numbers red

Regards

edit flag offensive delete link more

Comments

You are a legend! I don't know how I managed to change that setting on those 2 cells in the first place. Funnily enough, I asked on another thread how to make negative numbers show up in red and someone told me to use "conditional formatting". I couldn't figure out how to make negative numbers show up red using conditional formatting, but I did figure out how to make the background colour change to red if the result in the cell was negative, hence the reason that the background colour of the row

appreciatethehelp gravatar imageappreciatethehelp ( 2017-03-21 08:42:16 +0200 )edit

of cells at the bottom is red. In answering this question, you inadvertently answered another of my questions! Much obliged, Pierre.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-03-21 08:43:27 +0200 )edit

Thank you for the feedback :)

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-03-21 08:51:04 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-03-21 08:02:49 +0200

Seen: 163 times

Last updated: Mar 21 '17