red color negative numbers
I can't make it so that on numbers if the currency value is negative it is automatically written in red.
Thanks to anyone who can help me
iMac 24″, macOS 14.2
I can't make it so that on numbers if the currency value is negative it is automatically written in red.
Thanks to anyone who can help me
iMac 24″, macOS 14.2
Hi Dario,
You can apply a Conditional Format to change the text color for Negative Values as I have done in this example:
Best regards,
Jerry
Hi Dario,
You can apply a Conditional Format to change the text color for Negative Values as I have done in this example:
Best regards,
Jerry
Problem solved.
Thanks for your help
Dario,
Thanks for the feedback.
Jerry
Other options are available in the Format sidebar for showing negatives in red. Here are two:
I meant to say "there are two other options in the format sidebar" rather than implying there are more than two. Neither uses the negative sign but both are commonly used in accounting.
red color negative numbers