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
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …