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