4

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.

enter image description here

3

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.

  • Awesome. Thanks fixed it right up. – Joshua Dance Jan 6 '16 at 0:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.