Hello!
I am working on a spreadsheet in which I have a table full of data. I want to have Excel highlight the entire column that contains a maximum value. To clarify I have row headings like 'apple', 'banana', and 'pear', and column headings like '1', '2', and '3'. I want to highlight the maximum 'pear' value, but I ALSO want to highlight the rest of the column that the maximum 'pear' value is in. So if the maximum 'pear' value is in column '2', I want all of column '2' highlighted.

Any help on how to do this would be greatly appreciated.