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

Closed
ganesh7nadar Posts 1 Registration date Saturday July 8, 2017 Status Member Last seen July 8, 2017 - Jul 8, 2017 at 08:14 AM
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..