I recently tried to edit the conditional formatting for a column that was working correctly before and then change it back to the same exact formula it had before and now it isn't working correctly. The formula is =$W2<$U2 but it appears to be ignoring the less than the part. It highlights cells that are equal to and greater too as well. Both columns are formatted to numbers. I'm not sure why it worked before and doesn't want to work now. I tried completely deleting the conditional formatting and starting over. Same thing. Any ideas what the problem is?

Google Sheets conditional formatting problem

1 Answer 1


Looks like your Conditional Formatting is offset by 1 row because you applied it to range W1:W142 instead of W2:W142

enter image description here

  • 1
    Awesome, thank you! I was staring at that for about an hour trying to figure out what was wrong. Jul 25, 2019 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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