With the data in A1:Axxx, I selected A2:Axxx (omitted A1).

Then format|conditional formatting
formula is:
=AND(A2<"",A2=MAX($A$1:A2))
And gave it a red format

I ended up with quite a few red cells in my test data. But those red cells were
the highest so far.



James Silverton wrote:

Hello, All!

I did not think this would be a problem but I am having
difficulty setting it up. If the answer is RTFM, please tell me
where :-)

What I want to do is to have the contents of cell colored red if
it is greater than the maximum of all previous values in the
column.

TIA

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

--

Dave Peterson