I have a range of data that I am looking to format a certain way. I would like cell B1 to turn a certain color or have an up/down arrow based on the value of A1, but I'm looking for this to repeat for the entire range of data. PLease see the image for an example of what I am looking for. In this image, the cell turns green when the cell before it is lower, and red when it is higher.