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
Conditional Formatting
Conditional Formatting
- Attachments
-
- Conditions screen
- Conditions.PNG (11.53 KiB) Viewed 1888 times
-
- My formula that works
- Cashflow.PNG (12.28 KiB) Viewed 1888 times
Re: Conditional Formatting
Hello,
Please try to use the Expression type for Condition and your expression.
Thank you.
Please try to use the Expression type for Condition and your expression.
Thank you.
- Attachments
-
- Capture.PNG (35.34 KiB) Viewed 1884 times
Re: Conditional Formatting
That worked! Thanks again!
Re: Conditional Formatting
Hello.
We are always glad to help you.
Thank you.
We are always glad to help you.
Thank you.