Easy Way to Set Conditional Formatting?

[riodavid]

Hi Folks,

Let's say there's a $V{Value_1} in cell A. I want the font color turn to red if the value is below 0. It's easy to set the conditional formatting on it, just create a expression of "$V{Value_1} < 0".

But if I have multiple cells that contains multiple values $V{Value_2}, $V{Value_3}... $V{Value_n}, to implement conditional formatting, I have to create the expression for each of them.

Is there an easy way, just read the cell values rather than variable values,  and decide which formatting to choose?

Thank you

D

[riodavid]

I will be happy if some one tells me it's not possible