Not going to filter negative currency value

[Reshmi mohankumar]

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]

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)