Ok, it's probably very simple to do, but I'm having some trouble.
I have a worksheet of numbers, each day I add a new column of numbers.
I would like to format the new data entered so if the number is less than the previous column the background is red, if it is more than the previous column the background is green, if it is the same, than no background color.
When I tried to use conditional formatting, the new column keeps referencing the number in the first column, not the one previous.
Thanks
Bookmarks