on 10 May 2018 02:10:49
I have a slicer that allows users to select a range that is then used for calculations. I would also like to be able to use that slicer to set the min/max values for color diverging within the background and font conditional formatting so that it can be dynamic. Right now the only options are lowest value, hard coded number for min and highest value, hard coded number for max.