Autofiltering based on Cell Formatting
Posted by Jeff Mischler on July 31, 2001 6:32 AM
We need to autofilter a spreadsheet based on cell formatting. Such as filtering on a "Bold" font. We found an article on this at the Mircosoft web-site, the example works, but we do not know how to minipulate the formula to work with our spreadsheet. Were using Excel 2000 and this is for inventory control, setting minimum values to trigger a Bold font and then filter the bold fonts to a smaller list. Thanks for your help!