What is conditional formatting?
Conditional formatting is a feature commonly found in spreadsheet software, such as Microsoft Excel, Google Sheets, and similar applications. It allows users to automatically apply formatting—such as font color, background color, font style, or borders—to cells in a table based on specific conditions or criteria.
The primary purpose of conditional formatting is to visually highlight or emphasize certain values or trends within the data, making it easier for users to interpret and analyze. Instead of manually formatting cells based on data analysis, users can set up rules or conditions, and ERPAG will apply formatting automatically according to those rules.
Transform the ERPAG lists and data tables to insightful dashboards!
- Enhanced Data Visibility: Conditional formatting highlights important data points, making them more visible and easier to interpret within the table. By assigning different formats such as colors or alignment and font style, based on specified conditions; users can quickly identify trends, outliers, or significant values.
- Immediate Insights: With conditional formatting, insights become apparent at a glance. Users can set conditions to highlight cells that meet certain criteria, such as:
- sales figures exceeding a target
- inventory levels falling below a threshold
- project deadlines approaching
- expected date-missed
- Improved Decision-Making: By making key information stand out, conditional formatting facilitates quicker and more informed decision-making. Whether analyzing financial data, tracking project milestones, or monitoring performance metrics, users can promptly identify areas that require attention or action, leading to more effective decision-making processes.
Show case- examples
Selling price under the purchase price – NEGATIVE selling price margin warning
Go to MORE > columns, click FORMULA
Next: define the conditions
– for further detail and information, please refer to the below blog regarding formulas in custom columns:
NOW to open conditional formatting click the color icon next to the column name:
Next: define conditions in conditional formatting pop up
As you save changes – you will see colors in the column Negative selling price.
Conclusion
With this new feature, you will bring crucial information directly to the surface and speed up decision process significantly.
Transform your data in tables to colorful meaningful dashboards and don’t ever miss any important info in ERPAG or your Business!
Recent Comments