Andy Broomell Posted March 21, 2018 Share Posted March 21, 2018 Am I blind, or is "Fill Style" not on this list? I want to make a worksheet that lists all of the objects of a given type whose fill is set to NONE, but I can't seem to do that with the available criteria. Is there something I can type into the formula bar? Quote Link to comment
TKA Posted March 21, 2018 Share Posted March 21, 2018 did you try "fill pattern" set to None? - first "X" box in 3rd column? 1 Quote Link to comment
Pat Stanford Posted March 21, 2018 Share Posted March 21, 2018 Or in the formula FP=0 gives you objects with a None fill. Quote Link to comment
Andy Broomell Posted March 21, 2018 Author Share Posted March 21, 2018 (edited) 17 minutes ago, TKA said: did you try "fill pattern" set to None? - first "X" box in 3rd column? That worked, thank you! I would've assumed that was only useful when using Pattern Fills, but it indeed solves my current problem. But now I wonder, hypothetically, if I wanted to select rectangles with a Fill Type set to Gradient, how that'd be done? Edited March 21, 2018 by Andy Broomell Quote Link to comment
TKA Posted March 21, 2018 Share Posted March 21, 2018 I think this is another wishlist item that should be really easy to fix. I personally like having pull down menus for different choices as opposed writing scripts (which were driving me crazy especially at the end of the day). Having said that, I think all the pull down menus should be organized in a similar manner to classes - main and sub categories. Subs then could be expanded as per users feedback. Quote Link to comment
Pat Stanford Posted March 22, 2018 Share Posted March 22, 2018 It appears that FP returns a negative number for all of the "special" fill types, Gradient, Image, Tile, Hatch. Not a whole lot of use as it seems to be linked somehow to the order of the resources in the file. So it will probably be different for each file, but you can probably generate a worksheet database of selected object with column with formulas of =FP, =FF, =FB, =HFI and use that to figure out what you need on a file by file basis. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.