Here’s an example of how this should be set up:
Also a few things to keep in mind:
If you don’t supply FilePath input then this node will assume that you have a session of Excel open and will tap into that session. if you want to apply formatting to a closed session of excel saved on a drive just use a file path node.
With Cell Value Format Condition you can only define Fill Style. At the moment Excel allows to make changes to Text as well but some things are limited so I didn’t bother to enable Text at all. Let me know if that’s a hindrance and I can look at it in the future.
When defining fill style please see this:
I believe you were picking a xlSolid and then feeding in patternColor as well. With solid fill you only need one color and put it into backgroundColor input. When you want to do a pattern fill like diagonal then you need both.
I made a small change to code to handle file paths better so please download the latest version of Bumblebee.
Please post any future requests or bugs to this link: https://github.com/ksobon/Bumblebee/issues