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
Thanks


Have you tried to use quot;Cell Value Isquot; in stead of quot;Formula isquot;? If you
use quot;Cell value isquot; then you can use quot;equal toquot; for the second box,
and the third box fill in the max number. Use this for the first
section, then redo the cell value is for the second group. You can use
quot;format painter to do this quickly instead of plugging in the formula
again. Format painter is the paintbrush on your toolbar; just
highlight the group you want to copy the format of anything in that
cell, pick format painter, and higlight with your cursor the next group
and it will apply all formats...hopefully the same format applies in you
second group of numbers. Hope this works for you!--
Roz
------------------------------------------------------------------------
Roz's Profile: www.excelforum.com/member.php...oamp;userid=29746
View this thread: www.excelforum.com/showthread...hreadid=495221Try this. In a cell off to the side, let's say F1, type in your MAX formula
for the cells in question =MAX(A1:A500), or you can name the range
=MAX(quot;range namequot;). Then conditionally format A1 to reference F1... quot;Cell
Value Isquot; quot;Equal Toquot; quot;=$F$1quot;, then using the format painter, as Roz
mentioned, copy the format down your range of cells.

quot;Rozquot; wrote:

gt;
gt; Have you tried to use quot;Cell Value Isquot; in stead of quot;Formula isquot;? If you
gt; use quot;Cell value isquot; then you can use quot;equal toquot; for the second box,
gt; and the third box fill in the max number. Use this for the first
gt; section, then redo the cell value is for the second group. You can use
gt; quot;format painter to do this quickly instead of plugging in the formula
gt; again. Format painter is the paintbrush on your toolbar; just
gt; highlight the group you want to copy the format of anything in that
gt; cell, pick format painter, and higlight with your cursor the next group
gt; and it will apply all formats...hopefully the same format applies in you
gt; second group of numbers. Hope this works for you!
gt;
gt;
gt; --
gt; Roz
gt; ------------------------------------------------------------------------
gt; Roz's Profile: www.excelforum.com/member.php...oamp;userid=29746
gt; View this thread: www.excelforum.com/showthread...hreadid=495221
gt;
gt;