Posted by Jeff Mischler on August 27, 2001 7:36 AM
I am trying to get Excel to Autofilter based on a bold font. Here's my setup, I have a spreadsheet that we use for inventory, we have set minimums on our inventory using conditional formatting so when an item drops below a certain level its bolded and also has a color background. This helps alot, now we want to be able to autofilter the bolded font down at a smaller list that we can then print out. I found an example on the Microsoft web site with an exact example of this. In the example you define a "Name" that has a formula to filter on bold font, here it is,
In the worksheet then you have in two cells
This example works great, but I need help in modifying the formula to work with our spreadsheet. Our quantities are in Column D, about rows 7-343, thats the column we want to filter. If anyone can help with this it would be greatly appreciated! Hope this is enough infomation, thanks in advance!