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

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

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

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

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