You can use conditional formatting to highlight a cell or cells that meet certain conditions.
In the example, conditional formatting has been used to highlight the cells containing the maximum and minimum values.
The black border encloses the range called "NumRange"
The cells in that range are all conditionally formatted (From the menu: Format > Conditional Formatting...)
The example file (click on the link to download) demonstrates the above.