How would I write a max formula that included color formats?
 

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.

How would I write a max formula that included color formats?
 

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.

How would I write a max formula that included color formats?
 

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