Need to compare data on the work book by giving deferent colour [Closed]

Report
Posts
1
Registration date
Saturday July 8, 2017
Status
Member
Last seen
July 8, 2017
-
Hi
There are columns in a workbook with numbers in various cells.
I want to compare values in each column with the previous column.
Cell b1 should b green if value is greater than a1 and it should b red if its less than a1
Same way compre c1 with b1 and so on..

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!