Set conditional formatting by formula

AnaplanIdeas

Description of the enhancement required:
Improve conditional formatting by allowing formulas.

 

An example of the enhancement:
Have it function similar to excel where formulas can be used to test for conditions.

 

How would it help their business process:
Extra line items must be used to check for a condition, if conditional formatting would allow for a formula these would be unnecessary.

AnaplanIdeas

Status changed to: In Review

Joshua.Huilar

In the meantime, when setting up a Line Item to write a formula to manage Conditional Formatting logic what is best practice for naming conventions?

For example, in the attached screenshot, I have one Line Item as "CF" for "Conditional Formatting" and the other Line Item as "IND" for "Indicator". 

In the past I've had clients that thought "CF" was "Cash Flow" and it caused confusion hence why I started using "IND".

 

Thanks!

 

Daniel234

Hi, Does someone know a formula to use conditional formatting to ensure is = 100%?