Tried to setup a conditional format. Overall idea, I want a number to go down, and be marked red if it is going up.
I tried this custom formula
=if(F2>F3, true) trying to say, if the cell value is larger than the cell above it, mark it red.
I read in another answer that "Cell references without $ prefixes are adjusted automatically when applied to ranges as you would expect."
However it doesn't appear to be working. There are many cells where the value increased and they are not formatted correctly. I don't know of a way to see what the conditional format formula evaluates to.