conditional formating in erpag

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.

conditional formating settings popup in Erpag

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.


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!

Start NOW

Read More

Related Posts

How Great Inventory Software Can Help Fight Inflation

In today's rapidly fluctuating economy, businesses face the daunting challenge of fighting inflation. Rising costs can erode profits and disrupt operations, making it essential to adopt strategies that mitigate these impacts. One powerful tool in this battle is...

read more
Manufacturing analytics

Manufacturing analytics

In today's competitive business landscape, small manufacturing businesses face the constant challenge of improving efficiency and productivity while keeping costs in check. Thankfully, ERPAG, an intuitive and user-friendly ERP (Enterprise Resource Planning) software,...

read more
JSON / XML Designer

JSON / XML Designer

JSON/XML Designer in ERPAG is a visual tool that will allow users to transform data from the ERPAG database into JSON or XML format. This can be further used for future integration with API services. This tool provides a user-friendly interface where users can define...

read more