How to highlight the values in the column which is greater than or less than the other column values
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?
Best Answer

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.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work
Answers

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.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work

Thank you
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!