Select the first cell in the range (A1) then select the range of cells
(A1:A9), check that the first cell remains the active cell,
Format, Conditional Format, Formula is:
=A1=MAX(A$1:A$9)
and set the Pattern required.
Hope this helps
--
trainer07 Wrote:
I would like to write a max formula for a range of cells. I want the
number
that is the highest in that range (the answer to my formula) to be in
blue
font color so that it stands out.
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=535733