Hello,

I am new to VBA and I would like to know if there is a code to change the colour of the cells in this data set, depending on whether the cell is greater than or less than the cell above.

Annotation 2020-03-12 105511.png

For example, if A3 if greater than A2, then set font to green. If A3 is less than A2, then set font to red.

I would like to repeat this pattern for the entire data set located in Set A. I would also like to apply this same code for the data in column B.

However, for cell A2, I would like this to turn green if greater than B15, and red if less than B15. I would also like B2 to not be affected by any code. Basically B2 would be the starting point and A15 would be the end point.

Is this possible?

Thank you.