Below is the snapshot of what I did for the condition “test”. Only the hight value should have been hi-lighted. I just cannot see my “error”, can anyone advise me on this? Thanks.
Try making the range address absolute. MAX($C$2:$C$30)
robleyd,
That did it, thanks.
BTW - I never really got the hand of the absolute “$” power, maybe someday.