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