Select I9:I39, hold CTRTL and click on I305 - that's how to select
non-contiguous ranges
Use conditional format formula =I9=MAX(I9:I39, I305) - MAX can take up to
30 arguments
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"billy boy" wrote in message
...
Dave, that worked perfect, but now I'm trying to do the same thng but with
cells i9 thru i39 and i305.
Is that possible?

"David Billigmeier" wrote:

There are many ways, here is 1:

Select your range (in this case i'm assuming A1:A40), and go to
Format-Conditional Formatting-Check 'Formula Is', then enter this
formula:

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

Make sure (in this case that is) that the active cell is A1. Then choose
whichever formatting you would like.


--
Regards,
Dave


"billy boy" wrote:

I have a spread sheet with lots of data. The top row of each column
looks for
the max number in that column. Is there a way for excel to warn me when
entering data that the number I just entered was max in that column.
That
would really help me out. Thanks