Forum Discussion
Conditional Formatting in tables and graphs
Hi,
Is it possible to do conditional formatting in tables with more complicated fields than just "lowest & highest value" ? For instance you have two columns in a table, one having the sales for January and the other the sales for February and the rows are the different brands : I would like to highlight in the column February Sales the fields that are lower to February Sales. How would I do that?
Same logic for a graph: if you have a clustered column chart with 2 month and want to highlight when it's decreasing/increasing from one month to the other, how would you do?
Any ideas?
Thanks!
1 Reply
- v-qiuyu-msftCommunity Support
Hi sophie63,
As conditional formatting only support a static column, I'm afraid your requirement can't be achieved currently. You can vote on this similar idea: Dynamic conditional formatting.
Best Regards,
Qiuyun Yu