Hello, All!

I feel like an idiot because I somehow lost part of the kind
replies about using a function for conditional formatting and
can't refer to the poster properly. I tried the method and I
could not get it to work. I meant to come back to it today but
that is when I lost the post.

Anyway, I have a list of numbers in A1:A30 and I want to format
whichever of them is the minimum in red.

Following the posted instructions (as also given by
http://office.microsoft.com/en-us/ex...864831033.aspx)

I conditionally format A1 in red using the function
IF(A1=MIN(A:A))
I select A1, click Format Painter, select A1:30, click Format
Painter again

Nothing happens except that A1:A30 is outlined by the flickering
dotted lines!

Certainly, if I put B1 =IF(A1=MIN(A:A),"Minimum"," "), and copy
down, the minimum is indicated properly.

Pulling out my hair!

James Silverton
Potomac, Maryland

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