Jump to content

Criteria: Fill Style?

Recommended Posts

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 by Andy Broomell
Link to comment

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.

Link to comment

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.

Link to comment

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.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...