I would like to highlight the maximum numerical value in a particular column.
Take a look at this sheet: https://docs.google.com/spreadsheets/d/107c-9pET6SA1APwtGIJh1Qxi__SOXAHGtaGVGd5Nw6g/edit?usp=sharing
Or this screenshot:
This formula seems to actually be taking
A2 and replacing it with the cell being calculated. In other words, it's only checking this cell and all cells after it to find the max, and no cells before it.
How do I make sheets check all cells?