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?
|