If a calculation returns a negative number, I'd like the result to be displayed in red, or perhaps the background to be red. How do I format cells and/or font to do that, like in Excel Conditional Formatting?
Hi Ben,
Select the cells.
Format Panel > Cell > Conditional Highlighting
Alternatively, if you are using Currency format, choose a setting for negatives
Regards,
Ian.
Hi Ben,
Select the cells.
Format Panel > Cell > Conditional Highlighting
Alternatively, if you are using Currency format, choose a setting for negatives
Regards,
Ian.
Thank you for the response, but mine does not appear that way. I can't find a way to update anything when I search, and this is how the "Cell" and "Data" tabs appear when the cell I'm concerned with is selected.
Which version of Numbers are you using?
Is it possible you're using an old version of Numbers, from before the time Conditional Highlighting was added?
The font use also looks odd.. is this Numbers on the web? Windows?
I'm thinking that is the problem. I normally use the program on a ChromeBook (don't ask) but when I'm working offshore, it's on a Windows laptop. I notice with Windows that there doesn't seem to be any way that I can find to even update Numbers.
How do I change font color based upon a calculation result?
