Help with conditional formatting - highlighting a column of max values.

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.

Lady222,

could you post your workbook or a sample so that i may see exactly what you are doing?

I really wish I could, but unfortunately, this has to do with my company's budget, and I am unable to share the work.

Could you make a small sample, and post that. it doesn't have to be any real data, just something for me to look at to get an idea of what you are doing.