How to conditional format in Google sheets based on cell directly above it?

Question

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.

Answer 1

The upper left corner of the range is F2. The custom formula should be written as it applies to that cell. You have =if(F2>=F3,true) which means comparing the cell to the one below it.

To have comparison with the cell above, use =if(F2>F1, true) but it's simpler to write =F2>F1 which means the same thing.