How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel

Question

I have some heterogeneous friction measurements that I want to analyze:

I want to adjust the colors of maximum and minimum on a set of cells. For example, I want the MAX(C16,E16,G16,J16,L16,N16) to become automatically red and MIN(C16,E16,G16,J16,L16,N16) to become green, and so on for other rows. I would appreciate it if you could help me know if there is a built-in functionality in Excel to do so, or maybe I can have a macro (e.g., VB or Python) to do this.

Answer 1

See Conditional Formatting, which may be accessed via the Home tab's Conditional Formatting button or the Format menu's Conditional Formatting option:

And, using Top and Bottom: