Conditional Formatting for span of existing data

What is the problem or goal the end user is trying to solve or accomplish?

Currently you need to have static defined limits for your conditional formatting in the pivot table. They would like to have an automatic and dynamic range that changes with the data in the chart.

How are they solving it currently?

A series of conditional formatting rules - as a partial workaround

What is the recommended solution by the Customer?

Taking in the span of the existing data in a column, highlight wrt the range rather than a defined limit.