Get the code here https://www.bluepecantraining.com/vba-to-conditionally-format-top-bottom-values-in-excel-chart/

This video details the VBA code needed to conditionally format the top and bottom values in an Excel Chart.
------------------------