HTML - negative $$ in red - can anyone assist?

Discussion created by on Jun 4, 2018
Latest reply on Jun 5, 2018 by

I have created a few custom reports with HTML and am attempting to have the negative numbers report in red automatically.  The current formula I'm using is:


<b><center><font size="2">Variance:  &nbsp&nbsp<%=NumberFormat(Forecast Variance, "#,###")%><Center>


I've tried to utilize the formula below but the $$ don't report:


<b><center><font size="2">Variance: </font>&nbsp&nbsp<%=NumberFormat(Forecast Variance, "<font color="black">#,###</font>")%><Center></b>


Does anyone have any suggestions? Appreciate the assistance.

Audrey Mitch