Forum Discussion
Matrix Conditional Formatting
I want to give red color background if total value is greater than 10. And if less than 10 is should be green. But there is no option. Do you know any way?
Anonymous,
Try:
Avg. Sales = Divide([total sales] , [total transactions], 0)
Thank you this actually works.