How to highlight the values in the column which is greater than or less than the other column values

RUPESH KUMAR

Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?

Jason Albrecht

Hello @RUPESH KUMAR

One option is to set up a helper column for symbols (such as traffic lights).

In this column you'll enter a formula something like:

=IF(Ordered@row > [Cust. Order Amount]@row, "Yes", IF(Ordered@row < [Cust. Order Amount]@row, "No", "Hold"))

You'll then use the Conditional Formatting button in the tool bar (blue box in picture above) and set up similar to this:

I have only chosen to highlight the Customer Order Amount cell. You can change it to the Ordered cell, other cells, or the whole row.

Jason Albrecht

Hello @RUPESH KUMAR

One option is to set up a helper column for symbols (such as traffic lights).

In this column you'll enter a formula something like:

=IF(Ordered@row > [Cust. Order Amount]@row, "Yes", IF(Ordered@row < [Cust. Order Amount]@row, "No", "Hold"))

You'll then use the Conditional Formatting button in the tool bar (blue box in picture above) and set up similar to this:

I have only chosen to highlight the Customer Order Amount cell. You can change it to the Ordered cell, other cells, or the whole row.

RUPESH KUMAR

Thank you