Hi,
I have attached a sample packaged workbook and requirement for me here is to apply conditional formatting and logic as follows:
Consider the values from Profit and Sales, highlight the cell value which is nearest to zero.
For instance: Sub-Category: Accessories have a Profit of $41,937 which is nearest to zero compared to Sales ($1,67,380). So the cell value $41,937 must be highlighted.
Please advise how to achieve this.
Hi,
Something like this? If yes, please refer the attached workbook
Since all the profit values are lesser than Sales all of them are colored.
please refer the attached workbook for the calculations
Please refer the steps for conditional formatting from here
Hope this helps!
If this reply helps, mark it as helpful and correct
Manoj
