I might have misunderstood, but it seems after using the cursor to highlight
the cells you want, you could just use the Comditional Formatting under
Format to set the parameters for those cells. "Cell value is greater than or
equal to" would handle turning the cell a specified color if the number is
higher than what you specify.

"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