Ⓔ Highlight the minimum and maximum cell in a Google Sheet column #gafetip #itip15

Originally published at: https://eduk8.me/2015/05/ⓔ-highlight-the-minimum-and-maximum-cell-in-a-google-sheet-column-gafetip/

There are times when you are using a Google Sheet, such as collecting information in a form, where you would like highlight the minimum and maximum cell in a column. Google Sheets offers conditional formatting, which gives you the ability to change the formatting of a cell based on the contents of the cell. For…