Hi, it seems the options for conditional formatting on Data Bars in a Table is very basic. I want to custom colour the data bars in one column (current year) based on the values in another column (p...
Additionally would be great if the max value of the bar could be based on the column, rather than the entire set of values. (This needs to be a flag that can be turned on and off, but would be great to have this option as not all categories are created equal and sometimes we want to see outliers per column, not just overall.)
