With an input of 0, quartile returns the minimum value in the data.
The first rule highlights values greater than the 3rd quartile.
QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.
Highlight data by quartile
To highlight cells by quartile, you can apply conditional formatting with a formula that uses the QUARTILE function. In the example shown, we are using 4 different conditional formatting rules. Each rule highlights a quartile in the range B4:F11 using the QUARTILE function. The formulas look like this: =B4>QUARTILE(B4:F11,3) =B4>=QUARTILE(B4:F11,2) =B4>=QUARTILE(B4:F11,1) =B4>=QUARTILE(B4:F11,0) Note that we are highlighting quartiles in a specific order, starting with quartile 4 and ending with quartile 1. It's important that the formula be entered relative to the upper left most cell in the data, in this case cell B4.
