Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Conditional Formatting on a Filtered List

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ken - 12 Mar 2008 21:57 GMT
Excel2003 ...

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

Is this possible?  Thanks ... Kha
Ron Coderre - 12 Mar 2008 22:06 GMT
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
T. Valko - 12 Mar 2008 22:20 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.