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 "Cell Value Is" in stead of "Formula is"? If you
use "Cell value is" then you can use "equal to" 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
"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: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=495221

Try 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("range name"). Then conditionally format A1 to reference F1... "Cell
Value Is" "Equal To" "=$F$1", then using the format painter, as Roz
mentioned, copy the format down your range of cells.

"Roz" wrote:


Have you tried to use "Cell Value Is" in stead of "Formula is"? If you
use "Cell value is" then you can use "equal to" 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
"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: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=495221