Conditional Formatting
Posted: Thu Jul 29, 2010 4:28 pm
I have a number field that may be positive or negative. I have the text formatting set to show negative values as (1234) and they display properly.
I'd also like the negative numbers to be red (anything less than zero).
I "thought" that using the Conditions would work (the toolbar button that looks like a highlighter). However when I set a condition to set the color to red for values less than zero it doesn't work.
What needs to be done to make conditional formatting work?
Thanks
I'd also like the negative numbers to be red (anything less than zero).
I "thought" that using the Conditions would work (the toolbar button that looks like a highlighter). However when I set a condition to set the color to red for values less than zero it doesn't work.
What needs to be done to make conditional formatting work?
Thanks