When I do that and I formatt with yellow, I put 64 in the first cell and half
the yellow cells stay yellow and the other half stay white. Seems like
everytime I do it it does something different. Kinda wierd

"William Horton" wrote:

The below works for me. Substitute the cell where you want the format to
appear for A1 in the below formula.

=A1=MAX(G307:G327,G330:G360)

Hope this helps.

Bill Horton

"billy boy" wrote:

I'm trying to conditonal formatting cells to highlight yellow when the cell
is the max number. My problem is when trying to formatt the cells for example:
cell G307 thru G327 and then skip a few cells then cells G330 thru G360 it
does not work
I highlite just those cells and the formula i'm using is
=G307=MAX($G$307:$G$360)
is this the correct formula?

it works great if I don't skip any cells
Thanks

Perhaps you should select G307:G327,G330:G360 and use a CF formula of

=G307=MAX($G$307:$G$327,$G$330:$G$360)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"billy boy" wrote in message
...
When I do that and I formatt with yellow, I put 64 in the first cell and
half
the yellow cells stay yellow and the other half stay white. Seems like
everytime I do it it does something different. Kinda wierd

"William Horton" wrote:

The below works for me. Substitute the cell where you want the format
to
appear for A1 in the below formula.

=A1=MAX(G307:G327,G330:G360)

Hope this helps.

Bill Horton

"billy boy" wrote:

I'm trying to conditonal formatting cells to highlight yellow when the
cell
is the max number. My problem is when trying to formatt the cells for
example:
cell G307 thru G327 and then skip a few cells then cells G330 thru
G360 it
does not work
I highlite just those cells and the formula i'm using is
=G307=MAX($G$307:$G$360)
is this the correct formula?

it works great if I don't skip any cells
Thanks