Page 1 of 1

Conditional Formatting

Posted: Mon Nov 30, 2015 6:04 pm
by laducd
Hi,

I'm familair with the conditional formatting feauture in the report writer where you can format an existing field. What I am having trouble doing is formatting a formula based off of two fields. In essence I am looking to have this:

Field A Field B My Calculation and format=If Field A+Field B=negative,Red Text Color,Green Text Color

So if the result if my field is negative I want the text colored red. If it is positive I would like the text in green. Any thoughts on this? I've attached some screenshots. Thanks.

Best,

Andy Moncion

Re: Conditional Formatting

Posted: Tue Dec 01, 2015 6:16 am
by Alex K.
Hello,

Please try to use the Expression type for Condition and your expression.

Thank you.

Re: Conditional Formatting

Posted: Tue Dec 01, 2015 3:55 pm
by laducd
That worked! Thanks again!

Re: Conditional Formatting

Posted: Wed Dec 02, 2015 5:53 am
by HighAley
Hello.

We are always glad to help you.

Thank you.