In the following, K2 is less than J2, so it's highlighted in red:

enter image description here

Conditional rule

This was easy to achieve with the following conditional rule:

enter image description here


What's a good way to get that rule setup for the entire K column?

Link to sheet

Link to a view-only version of the document.


The data is from the Daily Treasury Par Yield Curve Rates of the U.S. DEPARTMENT OF THE TREASURY.


The idea here is to have a visual indicator of when the yield curve is inverted.

1 Answer 1


You can solve the problem in this way: color

  • Awesome answer. Thank you Daniele!
    – dharmatech
    Commented Apr 7, 2022 at 7:40

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.