Stephen McGee on 12 Jul 2022 08:33:44
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 (prior year) i.e. add red or green colours for the bar depending on the progress (if ahead of Prior Year it is green, if behind it is red).
Can you please consider improving the conditional formatting in future releases
Kind Regards,
Stephen
- Comments (2)
RE: Conditional formatting on Data Bars in a Table
Microsoft IdeaPlease also vote for this idea. This is also about conditional formatting on data bars, as well a a new idea of different conditional formatting for values and totals in background color and font color.
RE: Conditional formatting on Data Bars in a Table
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.)