software

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
ThanksThe 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

quot;billy boyquot; wrote:

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

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

quot;William Hortonquot; wrote:

gt; The below works for me. Substitute the cell where you want the format to
gt; appear for A1 in the below formula.
gt;
gt; =A1=MAX(G307:G327,G330:G360)
gt;
gt; Hope this helps.
gt;
gt; Bill Horton
gt;
gt; quot;billy boyquot; wrote:
gt;
gt; gt; I'm trying to conditonal formatting cells to highlight yellow when the cell
gt; gt; is the max number. My problem is when trying to formatt the cells for example:
gt; gt; cell G307 thru G327 and then skip a few cells then cells G330 thru G360 it
gt; gt; does not work
gt; gt; I highlite just those cells and the formula i'm using is
gt; gt; =G307=MAX($G$307:$G$360)
gt; gt; is this the correct formula?
gt; gt;
gt; gt; it works great if I don't skip any cells
gt; gt; Thanks
gt; gt;

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. quot;Cell value is greater than or
equal toquot; would handle turning the cell a specified color if the number is
higher than what you specify.

quot;billy boyquot; wrote:

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

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)quot;billy boyquot; gt; wrote in message
...
gt; When I do that and I formatt with yellow, I put 64 in the first cell and
half
gt; the yellow cells stay yellow and the other half stay white. Seems like
gt; everytime I do it it does something different. Kinda wierd
gt;
gt; quot;William Hortonquot; wrote:
gt;
gt; gt; The below works for me. Substitute the cell where you want the format
to
gt; gt; appear for A1 in the below formula.
gt; gt;
gt; gt; =A1=MAX(G307:G327,G330:G360)
gt; gt;
gt; gt; Hope this helps.
gt; gt;
gt; gt; Bill Horton
gt; gt;
gt; gt; quot;billy boyquot; wrote:
gt; gt;
gt; gt; gt; I'm trying to conditonal formatting cells to highlight yellow when the
cell
gt; gt; gt; is the max number. My problem is when trying to formatt the cells for
example:
gt; gt; gt; cell G307 thru G327 and then skip a few cells then cells G330 thru
G360 it
gt; gt; gt; does not work
gt; gt; gt; I highlite just those cells and the formula i'm using is
gt; gt; gt; =G307=MAX($G$307:$G$360)
gt; gt; gt; is this the correct formula?
gt; gt; gt;
gt; gt; gt; it works great if I don't skip any cells
gt; gt; gt; Thanks
gt; gt; gt;