Not going to filter negative currency value (1 Viewer)

Reshmi mohankumar

Registered User.
Local time
Today, 16:23
Joined
Dec 5, 2017
Messages
101
I tried to get all negative currency values by conditional formatting <0 . but it shows all positive values only. plz suggest me the way to resolve this.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 10:53
Joined
Feb 19, 2013
Messages
16,553
I suspect you need the format property, not conditional formatting

The format property for numbers has 4 conditions - positive, negative, zero, null.

So you might use

0.00,[Red](0.00)

to display

123.45
(543.44)
 

Users who are viewing this thread

Top Bottom