This formula uses two named ranges: data (B4:G11) and input (F2).
These are for readability and convenience only.
from a set of numeric data.
Highlight bottom values
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
