Change Fill Shape Color

[wapperdude]

The point around the guard function was to prevent the formula from getting clobbered, say, someone using the UI to change the color.  It is strictly optional.  All you do is enclose your formula with guard(your formula).

Since this is a custom shape, you could build the color change into the shapesheet as Vojo suggests. 

If your search macro is looking to change any and every shape, some of which may be simple shapes, others may be grouped like this one, then your code may need more developing such that when a grouped shape is identified, a sub-loop may be necessary to traverse the shapes within the group as the color will not always push down.

Wapperdude