Conditional Formatting in tables and graphs

[sophie63]

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!

[v-qiuyu-msft]

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