View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
QPapillon
 
Posts: n/a
Default conditional formatting - Highest

Hi - I'm trying to use conditional format to highlight the highest number in
a row of numbers derived from a formula. I tried MAX (a1:h1) but it
highlighted all the numbers.

What am I doing wrong?