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!