Excel2003 ...
I wish to conditional format (pattern RED) the MIN Value on a Filtered Col.
Is this possible? Thanks ... Kha
Try this:
With A1:B10 containing your list
Col_A contains Numbers....A1 is the heading
Col_B contains Text....B1 is the heading
Select A2:A10 (with A2 as the active cell)
From the Excel Main Menu:
<format><conditional formatting>
Condition_1:
Cell Formula is: =(SUBTOTAL(5,$A$2:$A$10)=A2)
Click the [Format] button and set the colors.
Click [OK]
The "5" argument in the SUBTOTAL functions returns
the MIN of the filtered amounts.
Consequently, the min Col_A value that is visible
in the filtered data will show the color.
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
> Excel2003 ...
>
> I wish to conditional format (pattern RED) the MIN Value on a Filtered
> Col.
>
> Is this possible? Thanks ... Kha
Assume the range of interest is B2:B10
With the entire range visible...
Select B2:B10
Goto Format>Conditional Formatting
Formula Is: =B2=SUBTOTAL(5,B$2:B$10)
Select the Patterns tab
Select your desired color
OK out

Signature
Biff
Microsoft Excel MVP
> Excel2003 ...
>
> I wish to conditional format (pattern RED) the MIN Value on a Filtered
> Col.
>
> Is this possible? Thanks ... Kha
Ken - 13 Mar 2008 12:25 GMT
The board strikes "pay dirt" again ... Thanks ... Kha
> Assume the range of interest is B2:B10
> With the entire range visible...
[quoted text clipped - 11 lines]
> >
> > Is this possible? Thanks ... Kha
T. Valko - 13 Mar 2008 19:11 GMT
You're welcome. Thanks for the feedback!

Signature
Biff
Microsoft Excel MVP
> The board strikes "pay dirt" again ... Thanks ... Kha
>
[quoted text clipped - 13 lines]
>> >
>> > Is this possible? Thanks ... Kha