Set conditional formatting by formula

Options

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.

14
14 votes

In Review · Last Updated

Comments

  • Status changed to: In Review
  • 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!

     

    Capture.JPG

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

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!