Negative numbers in red

[thead]

Is there a "style" or number format in a tabular data page that makes negative numbers red?

[April]

Hi Thead,

For you to change the number format in a tabular data page and change the color of negative numbers to red, please follow the below steps:

- Instead of showing the column with negative values, create an HTML block.

- Click source or disabled the HTML editor.
 

- Copy and paste this script.

<div id="mydiv[@field:ID]"></div>
<SCRIPT LANGUAGE="JavaScript">

if ("[@field:Value]" <0){

document.getElementById("mydiv[@field:ID]").innerHTML ="<span style='color:red;'> [@field:Value] </span>";

} else{
 

document.getElementById("mydiv[@field:ID]").innerHTML ="[@field:Value]";

}
 

 

</SCRIPT>

Hope this helps.

[Queso]

Hi!

Thank you for this! Now I can turn my negative numbers in red!

Just want to add a related thread: 

Have a good day!

[autonumber]

Hello! You can also refer to this post: 

 

[cheonsa]

Hello! 

You can also use this script. Just paste it in the Footer.

<SCRIPT LANGUAGE="JavaScript">
var elems = document.querySelectorAll("td[class^='cbResultSetData']");
for (var i=0, m=elems.length; i<m; i++) {
if (elems[i].innerHTML.charAt(0) == "-") { elems[i].style.color="red";}
if (elems[i].innerHTML.charAt(0) !== "-") { elems[i].style.color="black";}

}
</SCRIPT>