View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frank Drost
 
Posts: n/a
Default format cell with maximum value

I have a list of number, say 10rows by 10 columns. I want to specify a
conditional setting for each cell so that if the cell has the highest value
in its row, the cell will be coloured red. So I will get 10 cells that will
be coloured red. How do I do that?

Thanks