View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michelle michelle is offline
external usenet poster
 
Posts: 310
Default 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