I am currently compiling a table of pace per minute on this Gsheet.

I am looking to conditionally format the cells to highlight the minimum and maximum but cannot seem to find a formula for this online.

Would anyone know the formula for min and max on this section?

Thank you

Here's my current attempt at 'Min'


You should 2 rules




Adjust your ranges accordingly paying attention to the dollar sign $

enter image description here

| improve this answer | |
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos Apr 5 at 17:07

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.