Conditional formatting for negative and positive numbers

Hey everyone.

I am trying to make the result of a search be either red or green, depending upon if it is positive or negative. I’ve managed to get as far as “When this text is visible:formatted as number” but am unsure how to set out the formatting for it to display negative numbers as red, and positive numbers as green.

Any help appreciated as i’ve crawled through the forums to no avail.



Any ideas? I’ve spent a few hours trying to get it to work this morning but no luck.
I feel it’s something relatively simple that i’m not getting.

Make condition on element don’t use formatting. When number is <0
Then font color red.
And if it is text use convert to number first and do condition from second tab up. I don’t have laptop now i would’ve shown you

Hi Solinz,

An exmaple would be great as i’m not really following.

Just to be clear, I am not trying to use formatting, only conditionals.
I cant simply create a conditional that says “if this number < 0, make font colour green”. I’ll show you what i’m up against in snips below.

Let me know if you have any other suggestions.


This topic was automatically closed after 70 days. New replies are no longer allowed.