Conditional formatting
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
|