Is it possible to set the scale of a conditional format to the Max and Min of the values being displayed.
It is often the case that depending on which end user is reviewing the data the values there in are vastly different and setting a max and min that is unervisal is impossible.
Thank you,
Mark