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

[trainer07]

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.

[Mike Middleton]

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" <[email protected]> wrote in message
news:[email protected]...
>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]

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

--

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.