Formula to higlight highest and lowest values in row
I have a spreadsheet in Excel 2003 that shows different suppliers in the
columns, and different items in the rows. I need to find a formula that will
find the highest value for each item, and highlight it in green, and find the
lowest value for each item and highlight in red. Is this possible?
--
Michelle
|