Conditional Formatting on a Filtered List
 

Excel2003 ...

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

Is this possible? Thanks ... Kha

Conditional Formatting on a Filtered List
 

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)

"Ken" wrote in message
...
Excel2003 ...

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

Is this possible? Thanks ... Kha

Conditional Formatting on a Filtered List
 

Assume the range of interest is B2:B10
With the entire range visible...
Select B2:B10
Goto FormatConditional Formatting
Formula Is: =B2=SUBTOTAL(5,B$2:B$10)
Select the Patterns tab
Select your desired color
OK out


--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Excel2003 ...

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

Is this possible? Thanks ... Kha

Conditional Formatting on a Filtered List
 

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

"T. Valko" wrote:

Assume the range of interest is B2:B10
With the entire range visible...
Select B2:B10
Goto FormatConditional Formatting
Formula Is: =B2=SUBTOTAL(5,B$2:B$10)
Select the Patterns tab
Select your desired color
OK out


--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Excel2003 ...

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

Is this possible? Thanks ... Kha

Conditional Formatting on a Filtered List
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
The board strikes "pay dirt" again ... Thanks ... Kha

"T. Valko" wrote:

Assume the range of interest is B2:B10
With the entire range visible...
Select B2:B10
Goto FormatConditional Formatting
Formula Is: =B2=SUBTOTAL(5,B$2:B$10)
Select the Patterns tab
Select your desired color
OK out


--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Excel2003 ...

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

Is this possible? Thanks ... Kha