Is there a way in Excel to automatically highlight the max and min
values in a column? (Without writing any fancy scripts).

I know that there are max/min functions, but being able to highlight
the data point (or perhaps the entire row) instead of seeing the max/
min values in separate cells will make my life much more easier.

Mahurshi Akilla