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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!