Select A1:A20

Do format=Conditional Formatting

Change "Cell is" to "Formula is"

Enter this formula

=And(A1=MAX($A$1:$A$20),A125)

Set your pattern.

Regards,
Tom Ogilvy



Erche DP wrote in message
...


on the second thought...
the conditional formating is not working if i do this :

cell value equal to =max(A1:A20)25

what should i do.. i have to do the comparison to know that the value
already over limit...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!