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

Try this instead:

=A1=MAX($A$1:$H$1)

HTH,
Elkar

"QPapillon" wrote:

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?