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.
Bookmarks