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
|