Conditional Formatting on a Filtered List

[Ken]

Excel2003 ...

I wish to conditional format (pattern RED) the MIN Value on a Filtered Col.

Is this possible? Thanks ... Kha

 

[Ron Coderre]

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)

 

[T. Valko]

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

 

[Ken]

The board strikes "pay dirt" again ... Thanks ... Kha

 

[T. Valko]

You're welcome. Thanks for the feedback!