Forum Discussion

sophie63's avatar
sophie63
Helper I
9 years ago

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