Changing of Text Color based on Accounting Rules, Conditional Formatting, or Combination


Description: As the title suggests, allow for accounting rules as a boolean check box for numbers, so that they are auto-formatted to meet specific guidelines (or a profile that a user creates) such as the text is red when negative with paratheses and black when positive without paratheses.

Alternatively, allowing for full customization of the colorization of content within the cells, using conditional formatting or as a hard selection for each cells.

Example of Enhancement: Depending on how it is implemented, that any accounting practices would immediately use the accounting rules 'profile' of options or would construct their rules to meet the expectations of a ledger. 

Benefits: Easily assign different profiles to cells, modules, and models that make specific job roles, such as an accountant have pre-formated ready to go reports in real time that are business ready to display to clients, leadership, and follow the expected rules of business. Ease of use/visual guiding and understanding can be gained from clearly distinguishing text colorization in addition to the current options avalible.

40 votes

In Review · Last Updated


  • Status changed to: In Review
  • Status changed to: In Review
  • What specific formatting options are missing today? You can set most formatting at Line item level.
    Is the request for an easier faster way to apply the formatting, or for additional formatting options?

  • JB11

    Not the OP, but one highlighted already is changing negatives to display as red text with parenthesis. For example, ($10) vs. ($10), which is pretty common for financial outputs, budget vs. actuals, etc.

  • @Rebecca 

    Exactly what @JB11 has stated would be a huge improvement.

    Additionally allowing for a wider range of colors versus just the pre-selected 4-5 colors (which don't even include all color combinations of them) in conditional formatting would be useful. So I can select in the 32-bit color wheel any 3 colors and Anaplan uses a linear change across the 3 colors to change as expected.

    Allowing me to do things like black out cells unless it is negative, have a Red to Green (on 2 color) etc etc. 

  • Changing colors, either for text or cell background can be very helpful. In case there are tens of fields in a single grid, fields could be bunched together and color coded - e.g. - All green ones belong to current values, red ones belong to past, orange ones are suggested values. This could make a huge grid much more readable. 

  • @piyushjain Conditional formatting can be useful for your purposes.

    Create a line item that you will hide. Name it CF XXX, Conditional Formatting XXX, CF - XXX etc. and make some = none OR to min/max so that you can colorize the summary rows in your table(s). Use a reference to identify if the values are current, past, and suggested, and create a formula (I suggest if then else) that is equal to the type of row/version you are looking at. Then proceed to a view that you want the changed background on, and adjust your conditional formatting to equal the values that you assigned to each version.

    While yes, this is not optimal, it is a solution for the specific use case that you have identified.


    This Idea, is more to make it so that Anaplan follows rules in different business use cases, is more aligned to the particular use case if you identify the model as a specific type of color theme/scheme, and not have to set up conditional formatting for each line, cell, etc.

  • We did a survey to our more than 1200 end users in Anaplan. Better highlighting in tables the cells for read only, editable cells, mandatory or optional data input, conditional formatting based on value ranges, deviations...would be highly appreciated.

    Additional some options to frame sections like having a bold boarder to the total row and other would make the data tables much more easy to read.

    Thanks for taking this into account for future improvements. 

  • @Rebecca is this additional information sufficient?

  • >>such as the text is red when negative with paratheses and

         black when positive without paratheses.


    I need this function immediately!!

    I have asked this request by customers before, but we couldn't do it now😰

  • obriegr

    @Rebecca is there any update on this?

  • Thanks in advance for adding this feature into Reports pages too...

  • Upvoted for red text option to display negative numbers

  • PatrickE

    Upvoted for this request as well. Thanks!

  • tomgilbert
    edited April 29

    Agreed, conditionally formatting text color would great feature

Get Started with Idea Exchange

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