Conditional Formatting

Dear sir,
I have added column in sales order for current stock this fetches value of stock from closing stock.
I would like to change color to red if value is negative of closing stock, green if value is positive, yellow if value is 0. Please suggest codes

 

Color : If $$IsNegative:$$Value Then "Red" Else "Dark Green"

 

Working, Thanks...
Please suggest tripple condition it's double, red for negative dark green for other, but what about 0

 

Done by this code Color : If $$IsNegative:$$Value Then "Ref" Else If 0 then "Blue" else "Dark Green"
Thanks Brother

 

Super. Good Try. Keep it up..

 

How to delete company name and address in simple invoice
[#Part: INVSMP]
Deleteart: GST INVSMP COMPANY

 

Please check and correct following code as its working for value 1 but not for 2 and above
[Field : PKGVFDATA]
Use: Numbers
Set as: if (($BilledQTY)/($PackSizeStorage:StockItem:$StockItemName)) = 1 or 2 or 3 or 4 or 5 or 6 or 7 or 8 or 9 or 10 or 11 or 12 Then "P" Else "O"
Color: if (($BilledQTY)/($PackSizeStorage:StockItem:$StockItemName)) = 1 or 2 or 3 or 4 or 5 or 6 or 7 or 8 or 9 or 10 or 11 or 12 Then "Dark Green" else "Red"
Border: thin box
Scroll: Vertical
Width : 2
Align: Centre
invisible : not @@ISSALESORDER
Invisible: @@ISPurchase
Invisible: @@ISSALES
Skip: Yes
Border: Thin Left : $$InPrintMode
Add:Style:CLSTKSTYLE

 

;;Try the following:

Code:

Set as: if (($BilledQTY)/($PackSizeStorage:StockItem:$StockItemName)) IN (1, 2, 3, 4, 5) THEN "P" ELSE "O"

 

Please suggest how to delete the line in screenshot

 

Please Check Both Line You Have add Some Fields in Both Lines..

[#Line:Exp Inv Details]

[#Line:Exp Acc Details]