If you have a chart in Excel and want to emphasize the highest or lowest values in a way that changes with your data, changing them to a different color is the most effective method. Here’s everything you need to know about how to do it.
Source : How to Automatically Highlight the Min and Max Values in Excel Charts