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.

trainer07 -

In some cell enter =MAX(data_range)

Select all cells in the data range, choose Format | Conditional Formatting,
select the "cell value is" and "equal to," point to the cell containing the
maximum, and select the appropriate format.

- Mike
www.mikemiddleton.com

"trainer07" wrote in message
...
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.

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