ExcelBanter - highlight highest and lowest cells within a given column in excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - highlight highest and lowest cells within a given column in excel (https://www.excelbanter.com/new-users-excel/120898-highlight-highest-lowest-cells-within-given-column-excel.html)

Tim

highlight highest and lowest cells within a given column in excel

Is there a formula to highlight (in a different colour) a only the highest
and the lowest number in one column.
I am not sure if this possible to do in excel 2003.

All times are GMT +1. The time now is 04:13 AM.