یکشنبه بیست و سوم آذر ۱۳۹۹ - 15:17 - حسين حسين پور -
Highlight bottom values
Generic formula
=A1<=SMALL(data,N)
Summary
To highlight the smallest (bottom) values in a set of data with conditional formatting, you can use a formula based on the SMALL function.
In the example shown, the formula used for conditional formatting is:
=B4<=SMALL(data,input)