Negative numbers in red

[MGrey]

Simple really - here's hoping!

I have product prices (both - and +) that work well using the code below.

However, I need to have the negative numbers display in red and the positive
ones in blue. Is this possible? I've reviewed all the format tags;
DollarFormat, NumberFormat, etc, but none seem to have the ability to set
colour. I've thought of using cfset but I'm not sure where it should be
specified in the code below:

Thanks for all advice in advance,

Marcus G.


<cfif getoptions.RecordCount gt 0>
<div align="right">
<cfloop query="getoptions">
#NumberFormat(getoptions.price,'+_______,___.__')#
</cfloop>
</div>
</cfif>

[prayank]

hi MGrey

This is a simple coding issue, change the following lines from :
....
<cfloop query="getoptions">
#NumberFormat(getoptions.price,'+_______,___.__')#
</cfloop>
....
to :
<cfloop query="getoptions">
<CFIF #getoptions.price# GTE 0> <font color="blue" >
#NumberFormat(getoptions.price,'+_______,___.__')# </font>
<CFELSE>
<font color="red">#NumberFormat(getoptions.price,'+_____ __,___.__')#</font>
</CFIF>
</cfloop>

This should do it. :)

[Rob]

Instead of <font> you might want to use the more standard (and more
versatile)
<div style="color:red;">
type tag.

Just my 2 cents.
- Rob

[MGrey]

So simple, simple, simple!!!

Thanks prayank! I use this coding all the time but it just didn't hit me I could use it for the currency formatting - thanks again.