MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2000 Autofilter Based on Cell Formatting


Posted by Tim Mize on July 27, 2001 12:52 PM

I am trying to get XL2000 to autofilter based on Cell Formatting. I found an article on the Microsoft Web-Site about this, and the example they gave worked, but I do not know how to adjust the formula's to work with our spreadsheet. I want to filter based on either a bold font or a colored font. I have used conditional formatting to bold a quantity entry when it drops below a specific value, then I would like to autofilter this to find the items I need to re-order. Any help would be appreciated. Thanks alot!


Posted by Mark W. on July 28, 2001 6:00 AM

So, what have you done?

> ...but I do not know how to adjust the formula[s]...

What have you done to adapt the formulas from the
article to your worksheet? How is your worksheet
organized?