I have numeric data between columns F-N. I want to conditionally format cells based on the cells above, using a single formula across the range.

I'm using =$F$6:$N$6<$F$5:$N$5 as Formula but it only matches the first value and formats the entire selection in the same way.

  • 2
    See if: =F6<F5 works for you Apr 17 '19 at 19:20
  • @cybernetic.nomad, an explanation of why that's the solution could make a useful answer.
    – fixer1234
    Apr 17 '19 at 20:39
  • @SamikSengupta, if you use relative reference instead of Absolute then your formula also Compare Row to Row and highligh specific cells rather than Row!! Apr 18 '19 at 6:00

Your Answer

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

Browse other questions tagged or ask your own question.