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'

1 Answer 1


You should 2 rules




Adjust your ranges accordingly paying attention to the dollar sign $

enter image description here

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

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.