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

[Guest]

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

 

[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

--