Unofficial archive. This is a read-only, community-run archive of the Apple Support Community. It is not affiliated with or endorsed by Apple Inc.
craigdevans12
User level: Level 1 (8 points)

How to format negative numbers red in Numbers currency column on iMac

in numbers on iMac, I need to make all of the negative numbers red in the currency column.

Posted on Oct 30, 2026 9:04 AM

2 replies

VikingOSX
User level: Level 10 (131,878 points)

Oct 30, 2026 9:40 AM in response to craigdevans12

Format the block of cells to Currency as shown below:



Enter -234 in said currency formatted cell and watch it turn red on a return.



Tested: Numbers v15.4, macOS 27.2

craigdevans12 Author
User level: Level 1 (8 points)

Oct 30, 2026 2:39 PM in response to VikingOSX

Thanks 😊

Originally posted at discussions.apple.com/thread/256385963