Hello,
I have a table of sales for last 6 months for a product and state combination, I want to change color of a cell with green if in that row is Max Sales Value and Red if Its Min Sales Value.
Product Aug 20 Jul 20 Jun 20 May 20 Apr 20 Mar 20
A1 - CA 1200 1256 200 900 1800 225
A2 - NY 1201 1300 400 2800 1600 300
A1 - PA 1304 2000 830 800 400 500
For Row 1 Apr 20 1800 should be green background and Jun 20 should be Red
For Row 2 May 20 2800 should be green background and Mar 20 should be Red
For Row 3 Jul 20 2000 should be green background and Apr 20 should be Red.
Can anyone say how I can achieve this?
Thanks in Advance.
-V