How to dispay -ve numbers in red color
I have a numeric field. I want to display all -ve numbers of that field in red color. How can I do so?
Forum Discussion
Use a text formula field with some HTML allowed and a formula such as this:
If( [field] < 0,
"<span style='background-color: #EA3C53'>" & ToText([field]) & "</span>",
[field]
)
If( [field] < 0,
"<span style='background-color: #EA3C53'>" & ToText([field]) & "</span>",
[field]
)
- It works perfect to me, the only you need is to transform the last field in text :
If( [field] < 0,
"<span style='background-color: #EA3C53'>" & ToText([field]) & "</span>",
ToText ([field])
)
Thanks.
